Date/Time problem remote hosting

[jt]

Having a problem on trying to solve how to have the date and time displayed
correctly and entered into my ms access database.

I subscribe my web page being hosted remotely in Texas(CDT). I am logging in
here in Florida. Since there is a time difference and the date/time is
showing Texas(CDT) time rather than Florida time.

How can I make my asp code to recongzine Florida date/time? I guess I could
put in the offset but would have to change back and forth from EST to EDT
and would like if possilble to have it recongnized either EST or EDT when I
log in, I would guess.

Appreciate any pointers to this.

Thanks,
jt

[Aaron [SQL Server MVP]]

Re: Date/Time problem remote hosting

Since both Texas and Florida observe the same daylight savings time, you can
just always add an hour using DATEADD.

--

http://www.aspfaq.com/

(Reverse address to reply.)




"jt" <jtsoft@hotmail .com> wrote in message
news:GZ3Xc.5986 4$wM.1448@twist er.tampabay.rr. com...[color=blue]
> Having a problem on trying to solve how to have the date and time[/color]
displayed[color=blue]
> correctly and entered into my ms access database.
>
> I subscribe my web page being hosted remotely in Texas(CDT). I am logging[/color]
in[color=blue]
> here in Florida. Since there is a time difference and the date/time is
> showing Texas(CDT) time rather than Florida time.
>
> How can I make my asp code to recongzine Florida date/time? I guess I[/color]
could[color=blue]
> put in the offset but would have to change back and forth from EST to EDT
> and would like if possilble to have it recongnized either EST or EDT when[/color]
I[color=blue]
> log in, I would guess.
>
> Appreciate any pointers to this.
>
> Thanks,
> jt
>
>[/color]

[Evertjan.]

Re: Date/Time problem remote hosting

Aaron [SQL Server MVP] wrote on 25 aug 2004 in
microsoft.publi c.inetserver.as p.general:
[color=blue]
> Since both Texas and Florida observe the same daylight savings time,
> you can just always add an hour using DATEADD.[/color]

I heard that, unlike in Europe, the New World dst switch time is on it's
own local 02:00, so that this DATEADD will have the wrong time for 2 hours
a year.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress,
but let us keep the discussions in the newsgroup)

[Aaron [SQL Server MVP]]

Re: Date/Time problem remote hosting

> I heard that, unlike in Europe, the New World dst switch time is on it's[color=blue]
> own local 02:00, so that this DATEADD will have the wrong time for 2 hours
> a year.[/color]

They're one hour apart, so they will only be off for one hour of real time.

Anyway, you can deal with this using a calendar table, if it's really that
important. Since we know in advance when DST changeovers will take place...

See http://www.aspfaq.com/2218 for the basic idea...

[Evertjan.]

Re: Date/Time problem remote hosting

Aaron [SQL Server MVP] wrote on 25 aug 2004 in
microsoft.publi c.inetserver.as p.general:
[color=blue][color=green]
>> I heard that, unlike in Europe, the New World dst switch time is on
>> it's own local 02:00, so that this DATEADD will have the wrong time
>> for 2 hours a year.[/color]
>
> They're one hour apart, so they will only be off for one hour of real
> time.
>[/color]

1 hour twice a year is 2 hours a year, not?

;-)

Even so I like the European way,
changing over all three timezones at the same moment,
while understanding that it is unpractical for the many American zones.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress,
but let us keep the discussions in the newsgroup)

[jt]

Re: Date/Time problem remote hosting

Thanks for all your help.

jt

"jt" <jtsoft@hotmail .com> wrote in message
news:GZ3Xc.5986 4$wM.1448@twist er.tampabay.rr. com...[color=blue]
> Having a problem on trying to solve how to have the date and time[/color]
displayed[color=blue]
> correctly and entered into my ms access database.
>
> I subscribe my web page being hosted remotely in Texas(CDT). I am logging[/color]
in[color=blue]
> here in Florida. Since there is a time difference and the date/time is
> showing Texas(CDT) time rather than Florida time.
>
> How can I make my asp code to recongzine Florida date/time? I guess I[/color]
could[color=blue]
> put in the offset but would have to change back and forth from EST to EDT
> and would like if possilble to have it recongnized either EST or EDT when[/color]
I[color=blue]
> log in, I would guess.
>
> Appreciate any pointers to this.
>
> Thanks,
> jt
>
>
>[/color]