Re: unix_timesamp function out by a day when using a differenttimezone

2002-03-27 Thread Dominic Gamble
On Thu, 2002-03-28 at 12:15, Paul DuBois wrote: > > >Description: > >After setting the TZ environment variable to a different timezone, then > >using the UNIX_TIMESTAMP(...) function on a mysql timestamp string > >brings back the correct time, but a date that is a day out, but only > >for certa

unix_timesamp function out by a day when using a different timezone

2002-03-27 Thread Dominic Gamble
estamp repeat these steps for each of the 24 hours in the day for the original timestamp, and you will see that some of them will have different dates. >Fix: ??? >Submitter-Id: >Originator: Dominic Gamble >Organization: >MySQL support: [none | licence | email support | extended emai