asked on SQL Date Format
Hello Experts,
I have a SQL SELECT with the following condition:
...AND paymentDate >= '6/20/2012' AND paymentDate <= '7/4/2012'
paymentDate is actually a varchar.
The issue is that my statement does not returns the correct data, and after some digging, I have found that the values in paymentDate are sometimes 2010-04-30 and other times 7/13/2010.
I know that within my SQL SELECT I can take care of it by using I think CAST, but I not exactly sure how to go about doing it.
Any help will be greatly appreciated.
I have a SQL SELECT with the following condition:
...AND paymentDate >= '6/20/2012' AND paymentDate <= '7/4/2012'
paymentDate is actually a varchar.
The issue is that my statement does not returns the correct data, and after some digging, I have found that the values in paymentDate are sometimes 2010-04-30 and other times 7/13/2010.
I know that within my SQL SELECT I can take care of it by using I think CAST, but I not exactly sure how to go about doing it.
Any help will be greatly appreciated.
Microsoft SQL Server 2008SQL
Last Comment
lcohan
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You could use a statement like below to find all bad dates in that table:
select * from table_name where isdate(paymentDate ) = 0