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...????
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...????
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
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....!
Code: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)
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.
Bookmarks