How to get local time of a SQL server?

5 pts.
Tags:
C#
SQL
SQL Server
Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can get the local time of the SQL Server by using the getdate() system function.

SELECT getdate()

If you want to get UTC time use the getutcdate() system function.

SELECT getutcdate()

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    68,410 pointsBadges:
    report
  • danieljones

    You can also do this:

    SELECT CONVERT(datetime,

                   SWITCHOFFSET(CONVERT(datetimeoffset,

                                        MyTable.UtcColumn),

                                DATENAME(TzOffset, SYSDATETIMEOFFSET())))

           AS ColumnInLocalTime

    FROM MyTable

    2,840 pointsBadges:
    report
  • Brijesh
    I think you can use getdate() function which could get you with local time on SQL Server.
    14,450 pointsBadges:
    report
  • aemaldi
    GETDATE gets the time of the system in which is running the SQLSERVER...not the local time (the time of the system that runs de query)
    10 pointsBadges:
    report
  • ToddN2000
    As mentioned by others GETDATE() will get the time of the server the command is run on. In most cases this will be the local time unless you are running a corporate office running a multinational company on one server. If this is the case you would need to adjust the time to meet the true local time by +/- the hours difference.
    102,670 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: