David Gilden wrote: > Good evening, > > The following mySQL query works fine, but the server is in > California. I would like add 2 hours to %l, > because the client is in Texas. I could just go to time in GMT and > forget about it :) But I'm wondering if there is a simple solution > here. > > "SELECT id, DATE_FORMAT(datecreated, '%c/%e/%y at: %l:%i > %p'), email, name, comments FROM $table_name order by id limit > $offset,10;"
I don't use MySQL, but PostgreSQL has a SET TIME ZONE statement you can issue to define the "local" time zone for a session. Perhaps MySQL has a similar thing? -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
