Code Comments
Programming Forum and web based access to our favorite programming groups.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
Post Follow-up to this message"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?
Post Follow-up to this message"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
Post Follow-up to this messagerichardpstanton@yahoo.com (Richard Stanton) wrote in message news:<87bc8a5f.0410242312.3acd 2f2c@posting.google.com>... > "Chris Hohmann" <nospam@thankyou.com> wrote in message news:<OWo$10huEHA.2 632@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 f tp site.
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.