Post reply

How do i get Value of TimeStamp?

  • July 28, 2003 at 3:40 am

    #82308

    Hi,

    In SQL Server 8.0 When you add a new Record,

    it generates, timestamp value.

    Does sql Stores this in any global variable (may be similar to way it stores the value of the Identity Column.)

    or do we need to make specific select operation for that ?

    Can some one please update me this ASAP

    Thanking you i remain

    Mandar

  • July 28, 2003 at 3:44 am

    #467219

    Hi Mandar,

    quote:

    Does sql Stores this in any global variable (may be similar to way it stores the value of the Identity Column.) or do we need to make specific select operation for that ?

    are yoo looking for SELECT @@DBTS ?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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