Post reply

datatype doubts

  • June 27, 2013 at 2:18 am

    #279176

    Hi,

    In sqlserver ,

    If a column is declared as TIMESTAMP, can we specify to capture the

    date / time as Universal Coordinated Time (GMT) ?

    Are there automatic routines that run to synchronize the Server's Clock

    to the Naval Observatory's master clock?

    For TIMESTAMP datatypes, is the TIME ZONE automatically included with

    the date / time or must this be specified manually?

    Thanks

  • June 27, 2013 at 2:32 am

    #1627848

    What are you actually trying to accomplish here though? The TIMESTAMP data type isn't actually a date/time format, and I believe it's being withdrawn in future versions of SQL Server (and may actually not be in 2012, I haven't checked)

  • June 27, 2013 at 2:36 am

    #1627849

    Timestamp, despite it's name, has nothing at all to do with times. It's a binary value, automatically incremented whenever the record is updated. It's a row version indicator, not a time.

    If you're looking for a date with a time zone offset, you're looking for the DATETIMEOFFSET data type (2008 and above)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 27, 2013 at 3:02 am

    #1627865

    Thanks ...

  • June 27, 2013 at 3:43 am

    #1627885

    charipg (6/27/2013)

    Are there automatic routines that run to synchronize the Server's Clock

    to the Naval Observatory's master clock?

    Not from SQL Server, but you can setup Windows to sync.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

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