Post reply

TIMESTAMP WITH LOCAL TIME ZONE

  • August 6, 2003 at 4:31 am

    #176301

    What is the SQL Server Equlent of TIMESTAMP WITH LOCAL TIME ZONE and TIMESTAMP WITH TIME ZONE




    My Blog: http://dineshasanka.spaces.live.com/

  • August 6, 2003 at 4:40 am

    #468776

    GETDATE() and GETUTCDATE()

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 6, 2003 at 6:08 am

    #468783

    are there any data types equal to TIME ZONE in SQL SERVER




    My Blog: http://dineshasanka.spaces.live.com/

  • August 6, 2003 at 6:40 am

    #468789

    What's a "TIME ZONE" datatype? I mean, in what DBMS is it valid?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 7, 2003 at 1:10 am

    #468935

    Hi,

    FWIW just be aware that the TIMESTAMP data type isn't a time stamp at all - just a number that SQL Serve ensures is unique in each database.

    Cheers, Peter

  • August 7, 2003 at 1:25 am

    #468936

    ...and, just to confuse the us, the CURRENT_TIMESTAMP system function DOES return the current date/time as a datetime datatype.

    TIMESTAMP is a valid date/time datatype in DB2, so don't get it confused with that.

    Cheers,

    - Mark


    Cheers,
    - Mark

Viewing 6 posts - 1 through 5 (of 5 total)

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