June 28, 2006 at 3:39 am
Does anyone recognise the data type for the following string? 2004-05-13 00:00:00.000
If there is no datatype for this string can anyone please explain to me how I can convert it, perhaps through text manipulation (I have already tried to convert the datatype for the column that holds data in this format, without luck).
June 28, 2006 at 5:35 am
Thats the datatime datatype
June 28, 2006 at 5:36 am
I mean datetime
June 28, 2006 at 6:03 am
As Jaideep mentioned, this is a datetime data-type. You can use the CONVERT function to do manupulations on it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply