Inserting values into a database table I wished to add a date and time.
For this I used a convert
CONVERT(datetime, ’26/05/2014 14:21:00′)
However this will fail where the day value is too high. A value greater than 12 will be taken as an invalid month. Also the day and month will be saved swapped.
The date format should be defined as UK based, d/m/y
For this the country format value is included within the conversion.
CONVERT(datetime, ’26/05/2014 14:21:00′, 103)
In this example using 103 to handle UK date format
Note: also ensure there are no spaces at the start or end of the enclosed string.