Visolve DB Team wrote:
hi
MySQL automatically converts a date or time type value to a
number (numeric context) & viceversa.
When the server starts, it attempts to determine the time zone of the
host machine and uses it to set the *system_time_zone* system variable.
The value does not chang
he environment in which the server runs.
Thanks
ViSolve DB Team
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 23, 2006 8:11 AM
Subject: dates in mysql
> Hi all,
>
> Does anyone know how mysql stores dates?
>
> I'
Hi all,
Does anyone know how mysql stores dates?
I'm wondering whether it converts it back to UTC before storing it (and
back to the client timezone setting when you select) or whether it
leaves it "as is" with the timezone information.
So to change to a different timezone I'd have to conver
