Hi,
When using the Convert to format the Date in a select statement I dot seem to have any change in the display, can someone tell me if I am doing something wrong.
If I use convert(datetime, '31-dec-2010', 3) or convert(datetime, '31-dec-2010', 103) all I get for the results is
2010-12-31 00:00:00.000
Thanks,
Gavin,
When using the Convert to format the Date in a select statement I dot seem to have any change in the display, can someone tell me if I am doing something wrong.
If I use convert(datetime, '31-dec-2010', 3) or convert(datetime, '31-dec-2010', 103) all I get for the results is
2010-12-31 00:00:00.000
Thanks,
Gavin,