Re: inserting client time instead of server time
- Date: Wed, 14 May 2008 13:19:33 -0700
- From: "Rob Wultsch" <wultsch@xxxxxxxxx>
- Subject: Re: inserting client time instead of server time
On Mon, May 12, 2008 at 11:25 PM, Sebastian Mendel
<lists@xxxxxxxxxxxxxxxxxx> wrote:
> Hi,
>
> is there a way or a function like NOW() except it returns the client time
> and not the server time?
>
> --
> Sebastian Mendel
Timezone for the client is used for NOW(), but the client timezone
default to that of the server. You can reset this using "SET time_zone
= timezone;". There is probably some way to pass this as an argument
to the client so that you do not have to manually do it. I don't know
how to do this.
--
Rob Wultsch
wultsch@xxxxxxxxx
wultsch (aim)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx