Re: Date/Time

[Opec Kemp (WTFRC)]

Further to this problem I have discoverd a section in the MySQL
documentation regarding this. However, in my SELECT NOW() it did not return
value in GMT but in local date/time. The value of the date/time in the db
seems to be all stuffed up.
Here's the output of  SELECT NOW()

 1999-05-13 07:28:18

Where as the *actual* date/time was:
1999-05-13 03:28:00 EDT

I'm running a FreeBSD 3.0 Stable ELF system build with GCC version 2.7.2.1

MySQL info is:
Server version:        3.22.16a-gamma
Protocol Version     10
Connection              localhost via TCP/IP
TCP port                3306

> Hi how do I set Mysql internal date and time values?. The problem I'm
having
> at the moment is that the time when I do SELECT NOW() is now in sync with
> the System time , it is somewhat 5 hours the different. this is causing me
a
> lot of problem as I rely on mysql date/time function heavily in my
programs.
>
> thank you.
>