April 25, 2014 at 11:00 am
I have the DB server in EST timezone.So all the dates do get stored in EST.
But in the procedure before processing the date, I need to convert the date
to Specific timezone dates i.e. to either PST or CST etc.
The info available with me is WindowsTimweZone as shown below:
000 Dateline Standard Time (GMT-12:00) International Date Line West
001 Samoa Standard Time (GMT-11:00) Midway Island, Samoa
002 Hawaiian Standard Time (GMT-10:00) Hawaii
003 Alaskan Standard Time (GMT-09:00) Alaska
004 Pacific Standard Time (GMT-08:00) Pacific Time (US and Canada); Tijuana
010 Mountain Standard Time (GMT-07:00) Mountain Time (US and Canada)
013 Mexico Standard Time 2 (GMT-07:00) Chihuahua, La Paz, Mazatlan
April 25, 2014 at 11:07 am
MVIT (4/25/2014)
I have windowsTimeZone available for each client , based on this how can I convert the date to either EST/PST/CST etc
I guess we need more information as your question is rather vague.
April 25, 2014 at 11:07 am
Not entirely sure I understand the question. Generally, store the time as UTC in the database, and let the client convert to local time.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply