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

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

2002-03-27 Thread Paul DuBois
> >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 certain dates. It seems that the date becomes the original date