Post reply

Creating Timestamp column

  • April 14, 2011 at 3:01 am

    #99658

    Hi All,

    I'm trying to insert data using DTS package into a new table but in the new table I need to create a timestamp column. I have used the following script but it is not creating the right format of the timestamp:

    create table

    (

    productid varchar(),

    description(),

    timestamp

    )

    and the result I am getting is :

    Productid ProductDescription Timestamp

    890 testdescription 0x0000000003448F

    Thank you

  • April 14, 2011 at 3:18 am

    #1311478

    Timestamp, despite its name, is for row versioning and not for recording times of action. Create your column with datetime data type, and insert GETDATE() into it.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply