Data Retrieval
-
I have a problem of trying to find the query for finding invalid dates in my table which does not follow the following formats. Given are the valid formats: 1. 10/1/2007 2. Thu Sep 20 06:32:10 GMT-0400 (EDT) 2007 3. 10/1/2007 5:00 Can anybody please help me regarding this? Thanks in advance. :)
-
I have a problem of trying to find the query for finding invalid dates in my table which does not follow the following formats. Given are the valid formats: 1. 10/1/2007 2. Thu Sep 20 06:32:10 GMT-0400 (EDT) 2007 3. 10/1/2007 5:00 Can anybody please help me regarding this? Thanks in advance. :)
try this
select convert(varchar(10),cast(datevalue as datetime) ,120) from dateformats where convert(varchar(10),cast(datevalue as datetime) ,120) ='2007-10-01'Date Thu Sep 20 06:32:10 GMT-0400 (EDT) 2007 will not work for this query because it will cause convertion error exception.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com