Convert pst to est

[Gruss]

One of my friend was asking that how to convert pst to est???? Actually he was given a database in which he has to change from pst time zone to est time zone.... Can anyone Help here...????

[chroma]

Hi Gruss!

You just need to add 3 hours to the PST timing. I mean it is quite simple add 3 hours to the time you want to convert it to EST timing. Just follow the example as given below :

For Example :
11:35 AM PST = 2:35 PM EST

[Macarenas]

Following is the code given to do your work easy just if you know coding then put it in the VB & will solve your problem....!

Dim d As DateTime
d = DateTime.Parse("MAY 26, 2009 12:00:00 AM") 'date assignment
d = d.AddHours(3.0)
' - displays 10/26/2003 03:00:00 AM – an ERROR!
MsgBox(d.ToString)

[Sam.D]

If you know coding in SQL Server then use DATEADD(hh,-3,GETDATE()) - will give a new datetime value representing three hours prior to the given date/time.