The following will work for you and take into account daylight savings correctly. However, there are two important caveats:a) Your system should be using Pacific time (i.e., getdate() should return pacific time).b) You can't go back and do the conversion for dates that are in daylight savings period if you are currently in standard time period and vice versa.