Take your career to the next level with convenient certification training. Start your 7-day Free Trial
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
insert into chequetmp
where convert (datetime,estimado)>= '20150209' and convert(datetime,estimado) <= '20150210'
Open in new window
WHERE ISDATE(estimado) = 0
CREATE TABLE #tmp (val varchar(10))
INSERT INTO #tmp (val) VALUES ('01-01-2010'), ('05-24-2016'), ('12-25-0001'), ('banana')
-- All values
SELECT * FROM #tmp
-- Values that can't be converted to a date
SELECT * FROM #tmp WHERE ISDATE(val) = 0
Insert into chequetmp
select * from nopagados
where convert(datetime,estimado,103) between convert(datetime, '02/09/2015', 103) and convert(datetime, '02/09/2015', 103)
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment