--- Ian <[EMAIL PROTECTED]> wrote:
> I've spent most of today reading up on PHP and on problem i have so
> far is my MySQL server's timezone is at 0000hours and i need it to
> save the info as -0500hours. I read on php.net using Z and then like
> -0500 but nothing works for me, every registration i do keeps saving
> in 0000hrs. Anyway to offset to DATETIME to the -0500hrs needed?
>
> $query = "INSERT INTO users (first_name, last_name, email, password,
> registration_date) VALUES ('$fn', '$ln', '$e', SHA('$p'), NOW())";
My experiences have suggested that the time stored for MySQL fields is based on
the server time. What is your server's time zone setting?
James
