Post reply

server time

  • September 26, 2011 at 8:11 am

    #257911

    Hi Frndz,

    How to get the server time?

    Thanks,
    Charmer

  • September 26, 2011 at 8:15 am

    #1386521

    SELECT GETDATE()

  • September 26, 2011 at 9:43 am

    #1386608

    assume if im a client side..and im connectiong to server....i want to know the server date and time..? is it possible?

    Thanks,
    Charmer

  • September 26, 2011 at 9:44 am

    #1386610

    prakash 67108 (9/26/2011)

    assume if im a client side..and im connectiong to server....i want to know the server date and time..? is it possible?

    Do you ACTUALLY try what I write?

    getdate returns the server's date & time.

  • September 26, 2011 at 9:51 am

    #1386615

    if you are interested in Nano seconds.

    then use;

    select SYSDATETIME()

  • September 26, 2011 at 11:25 am

    #1386689

    SQL Server queries the Windows host date/time. This is used for all it's internal time marking of events (trace, events, etc.) and it is returned by getdate() or SYSDATETIME()

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

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