Timezone

[Sehboo]

I have stored datetime in UTC format in databases. I have one
database for each customer. Customers could be all over the US. They
connect to our website, and based on their profile, I know which
timezone they are coming from. Webserver is sitting in Chicago, but
customer could be coming from LA, NY, etc.

When I do .ToLocalTime(), it is converting the time according to
chicago's time, but I need to show the time in LA, NY, etc (depends on
where the customer is coming from).

I am not sure how to achieve this.

[VJ]

You need client side time, so your ToLocalTime() should execute as Client
side code, however that is done in ASP or ASP.NET. I think you are executing
a server side code.. I am not a expert in ASP.

VJ

"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

>I have stored datetime in UTC format in databases. I have one
database for each customer. Customers could be all over the US. They
connect to our website, and based on their profile, I know which
timezone they are coming from. Webserver is sitting in Chicago, but
customer could be coming from LA, NY, etc.

When I do .ToLocalTime(), it is converting the time according to
chicago's time, but I need to show the time in LA, NY, etc (depends on
where the customer is coming from).

I am not sure how to achieve this.

[Sehboo]

Yes, I am writing this in asp.net and C#. This is VS2003.

[VJ]

alright, the you have to execute it on client side.. so I assume you have to
have a clientside script run in your HTML? If I am right?

VJ

"VJ" <no***********@yahoo.comwrote in message
news:Ob**************@TK2MSFTNGP06.phx.gbl...

You need client side time, so your ToLocalTime() should execute as Client
side code, however that is done in ASP or ASP.NET. I think you are
executing a server side code.. I am not a expert in ASP.

VJ

"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

>>I have stored datetime in UTC format in databases. I have one
database for each customer. Customers could be all over the US. They
connect to our website, and based on their profile, I know which
timezone they are coming from. Webserver is sitting in Chicago, but
customer could be coming from LA, NY, etc.

When I do .ToLocalTime(), it is converting the time according to
chicago's time, but I need to show the time in LA, NY, etc (depends on
where the customer is coming from).

I am not sure how to achieve this.

[Sehboo]

I am not sure how to run asp.net as client side.

[VJ]

you can't, but you can have a client side script in your web page's html,
that does the job for you.

Post in ASP.NET forum you might get a quick trick or tip on that.
VJ

"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.com...

>I am not sure how to run asp.net as client side.

[Sehboo]

Well that is not goint to work because we have about 100 pages with so
many fields on those pages with date/time. What I have at this point
is that in the guts of the system, I am changin the time to show the
localtime, but that local time is server's time (chicago), and not
NY's time where the customer is coming from.

On Mar 15, 10:44 am, "VJ" <[e-mail]:

you can't, but you can have a client side script in your web page's html,
that does the job for you.

Post in ASP.NET forum you might get a quick trick or tip on that.
VJ

"Sehboo" <[e-mail] in message

news:11**********************@n59g2000hsh.googlegr oups.com...

I am not sure how to run asp.net as client side.- Hide quoted text -

- Show quoted text -

[VJ]

Other way is if you know in ASP code where the client is coming form, then
write a switch statement do the time translation yourself.. Not the best
way, but may work for you considering the thick of things you are in.

VJ

"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@d57g2000hsg.googlegr oups.com...

Well that is not goint to work because we have about 100 pages with so
many fields on those pages with date/time. What I have at this point
is that in the guts of the system, I am changin the time to show the
localtime, but that local time is server's time (chicago), and not
NY's time where the customer is coming from.

On Mar 15, 10:44 am, "VJ" <[e-mail]:

>you can't, but you can have a client side script in your web page's html,
that does the job for you.

Post in ASP.NET forum you might get a quick trick or tip on that.
VJ

"Sehboo" <[e-mail] in message

news:11**********************@n59g2000hsh.googleg roups.com...

>I am not sure how to run asp.net as client side.- Hide quoted text -

- Show quoted text -

[Ben Voigt]

"VJ" <no***********@yahoo.comwrote in message
news:u5**************@TK2MSFTNGP05.phx.gbl...

Other way is if you know in ASP code where the client is coming form, then
write a switch statement do the time translation yourself.. Not the best
way, but may work for you considering the thick of things you are in.

You can probably store for each client, the time offset from GMT. Then you
won't need ugly switch statements, but a lookup for the client's timezone
and simple date/time arithmetic. GetSystemTimeAsFileTime returns the
current time in a format quite convenient for arithmetic, then you would
convert afterwards to year/month/day style for formatting.