MS SQL 2012 Problem with converting date
Posted on 2013-11-06
I've adapted the following from a question I asked on here to convert nvarchar to a date into a new table:
SELECT *, convert(smalldatetime,Pres_Start, 103) as Pres_Start_date
WHERE ISDATE(Pres_Start) = 1
) as Pres_Start_Date;
The resulting table doesn't have all the records in it that I would expect, e.g. for one record, the original Pres_Start was 26/01/2013 and that record isn't copied over. I really don't understand why as I've used "103" to signify a British date format.
Please could someone tell me where I'm going wrong?
Thanks for your help.