Utc And Pst

Warning!PST has automatically switched to PDT

Is there a straightforward way to convert UTC timestamps in SQL Server (T-SQL) to PST timestamps which also takes care of DST. I have column called X which contains datetime in UTC and I want to create one more column Y which will have times in PST, it should be less 7 or 8 hours than UTC timestamp depending on if DST was in effect or not.


  1. Pacific Standard Time (PST) is 8 hours behind Coordinated Universal Time (UTC). This time zone is in use during standard time in: North America. This time zone is often called Pacific Time. See full time zone map.
  2. UTC, Coordinated Universal Time, popularly known as GMT (Greenwich Mean Time), or Zulu time. Local time differs from UTC by the number of hours of your timezone. GPS, Global Positioning System time, is the atomic time scale implemented by the atomic clocks in the GPS ground control stations and the GPS satellites themselves. GPS time was zero.

PST stands for Pacific Standard Time (NOT in use)

See All Results For This Question

PDT stands for Pacific Daylight Time (in use)

UTC stands for Coordinated Universal Time (in use)

Related conversions (with same timezone Abbr)

04:30:58

Utc And PstUtc pst estUtc And Pst

Utc And Pst Time Difference

Zulu to eastern daylight time. Friday, May 7, 2021

11:30:58

Friday, May 7, 2021

PDT(Pacific Daylight Time) and UTC(Coordinated Universal Time) Mapping Table
PDT (Pacific Daylight Time)UTC (Coordinated Universal Time)
00:0007:00
01:0008:00
02:0009:00
03:0010:00
04:0011:00
05:0012:00
06:0013:00
07:0014:00
08:0015:00
09:0016:00
10:0017:00
11:0018:00
12:0019:00
13:0020:00
14:0021:00
15:0022:00
16:0023:00
17:0000:00+1 day
18:0001:00+1 day
19:0002:00+1 day
20:0003:00+1 day
21:0004:00+1 day
22:0005:00+1 day
23:0006:00+1 day

PDT (Pacific Daylight Time)

Utc And Pst

And

Pacific Daylight Time(PDT) is 07:00 hours behind Coordinated Universal(UTC) Time.This timezone is a Daylight Saving Time timezone and is used in: North America

Utc And Pst Time

Typical City of PDT (Pacific Daylight Time)

USA - Los Angeles (Summer)

UTC (Coordinated Universal Time)

Difference Between PDT And PST

Coordinated Universal Time(UTC) has no offset from Coordinated Universal(UTC) Time.