I have varachar(50) field which have date in yyyymmdd format
Now i have to filter the data which are greater then server date
I have following query
Select * from MDB_CONTENT_INFO
Where convert(datetime, CON_SCHEDULED_INDUCTION_DATE,112) >= GetDate()
Problem ist aht i may have some invalid data other then valid one.
I am getting error
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Conversion failed when converting date and/or time from character string.
I wanted to exclude those records but currently getting error for the query
asKamran Shahid Senior Software Engineer/Analyst (MCP,MCAD,MCSD.NET,MCTS,MCPD.net[web])
View Complete Post