Query to get PST time

Question

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

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

SQL Surfer '66 SSCertifiable Points: 5161 More actions · Answer 1

I would probably use

SELECT GETDATE() AT TIME ZONE '<Full name of time zone>';

DesNorton SSC-Insane Points: 24399 More actions · Answer 2

vsamantha35 wrote:

Hi All, I have a question, using sql query can I get the current IST time and current PST time ? Thanks, Sam

Pacific Standard Time - Note: This time zone is used as a DST during winter. During the summer, Pacific Daylight Time is in use.

There are multiple time zones known as IST. Which one are you looking for?

Indian Standard Time - Note: This time zone has no DST component.
Irish Standard Time - Note: This time zone is used as a DST during summer. During the winter, GMT is in use.
Israel Standard Time - Note: This time zone is used as a DST during summer. During the winter, Israel Daylight Time is in use.

To the best of my knowledge, SQL has no way of determining DST. You have to maintain a list of when it takes effect, and code for it yourself.

How to post data/code on a forum to get the best help.

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 3

Actually, sys.time_zone_info has an is_dst_enabled column you can use here. SQL Server should match this up correctly.

Time zones are tricky, but this might help you:

DECLARE @t DATETIMEOFFSET = SYSDATETIME() AT TIME ZONE 'India Standard Time';

SELECT @t
, @t AT TIME ZONE 'Pacific Standard Time'

vsamantha35 SSChampion Points: 11551 More actions · Answer 4

SSChampion

Points: 11551

July 11, 2019 at 6:34 am

Thank you All.