Post reply

2004-05-13 00:00:00.000 What is the datatype for this string?

  • June 28, 2006 at 3:39 am

    #118521

    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

    #646331

    Thats the datatime datatype

  • June 28, 2006 at 5:36 am

    #646333

    I mean datetime

  • June 28, 2006 at 6:03 am

    #646337

    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