| Author |
Weird date/time problem
|
|
| Richard Stanton 2004-10-24, 8:55 pm |
| Hello all
I have a simple asp script that pulls data from an ingres database and
displays it on screen.
It all works fine except for date/time fields where the date >=
24/10/2004 and <= 31/10/2004 where it takes 1 hour off the time ie
in the database I have 24/10/2004 08:00
the asp displays 24/10/2004 07:00
The same thing happens for the same date next year.
Any thoughts?
thanks
Richard
| |
| Chris Hohmann 2004-10-24, 8:55 pm |
| "Richard Stanton" <richardpstanton@yahoo.com> wrote in message
news:87bc8a5f.0410241417.74a48bfe@posting.google.com...
> Hello all
>
> I have a simple asp script that pulls data from an ingres database and
> displays it on screen.
>
> It all works fine except for date/time fields where the date >=
> 24/10/2004 and <= 31/10/2004 where it takes 1 hour off the time ie
>
> in the database I have 24/10/2004 08:00
>
> the asp displays 24/10/2004 07:00
>
> The same thing happens for the same date next year.
>
> Any thoughts?
>
> thanks
>
> Richard
Could it be your daylight savings setting?
| |
| Richard Stanton 2004-10-25, 3:55 am |
| "Chris Hohmann" <nospam@thankyou.com> wrote in message news:<OWo$10huEHA.2632@TK2MSFTNGP10.phx.gbl>...
> "Richard Stanton" <richardpstanton@yahoo.com> wrote in message
> news:87bc8a5f.0410241417.74a48bfe@posting.google.com...
>
> Could it be your daylight savings setting?
Well I wondered that. Checked the server and the time is correct.
Richard
| |
| Richard Stanton 2004-10-25, 3:55 pm |
| richardpstanton@yahoo.com (Richard Stanton) wrote in message news:<87bc8a5f.0410242312.3acd2f2c@posting.google.com>...
> "Chris Hohmann" <nospam@thankyou.com> wrote in message news:<OWo$10huEHA.2632@TK2MSFTNGP10.phx.gbl>...
>
> Well I wondered that. Checked the server and the time is correct.
>
> Richard
Solved it - needed to install a patch, 9182, onto the nt clients from ca's ftp site.
|
|
|
|