British Summer Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a database that uses information from a vehicle tracking softawre
package. This records that dates and times of movements. My database
produces exception reports based on times etc. but with BST I need to add 1
hour on to all the times. This I have done but is there any way to check and
see if BST has been applied to save me in October stopping the 1 hous
addition.

I hope taht thsi makes sense.
Thanks in advance for any help.
HGraham
 
The Windows OS automatically switches to Daylight Savings Time (U.S.). Does
it not do so for the British version? It the OS changes the time, there
should be no impact on your time calculations.

The only thing you may need to consider is any calculations that would cross
the time change boundry. For example, If the Change Date is October 1 at
02:00, you would need to see if the from is prior to that and the to is after
than, then you would need to adjust the calculation.
 
Hi I know thsi but the tracker system is still reporting in GMT so if I am
looking for movements between 5pm and 6pm then transactions are recorded as
between 16.00 and 17.00. If I add 1 hour on to the transactions then
everything is fine but I want to check to see if Daylight Savings Time (BST)
has been switched to. If it has then I will add 1 hour if not then I will
leave the transactions alone.

Regards
Graham
 
I have no idea where you might check that. It is possible there may be a
Windows API call that could do it, but I would not know it. The only thing I
can think of is to check the system date/time against the designated
date/time BST goes into or out of effect.

BTW, I was unaware there is a summer in Britian. Is that the two weeks in
August when the fog lifts and it stops raining :)
 
Back
Top