On Mon, May 12, 2008 at 11:25 PM, Sebastian Mendel <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]