you have to standardize somehow. there are couple options.
1) store both datetime and timezone always.
2) store datatime and offset from gmt
3) store all datetimes in starndard zone, say gmt
you business layer should convert all datetime what standard you pick. this
means entry/display datetimes require specification of the timezone or
offset form stabdard. you can default this for the website or user.
-- bruce (sqlwork.com)
"Dotnet Gruven" <do**********@newsgroup.nospam> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hi,
If a server is physically localled in CST and is shared, how can one
create a Web Application on that server that has its timezone for EST???
I've seen other threads in this group that talk about using UTC/GMT and
also getTimezoneOffset(), but in this case, the business rules are such
that the Web App be based upon the time zone that the physical business is
located.
TIA,
geo