I've used DATE_ADD function in MySQL for similar purposes: "SELECT id, DATE_FORMAT(DATE_ADD(datecreated, INTERVAL 2 HOUR), '%c/%e/%y at: %l:%i %p'), email, name, comments FROM $table_name order by id limit $offset,10;"
Todd F. ----- Original Message ----- From: "David Gilden" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 27, 2003 11:06 PM Subject: SQL question // date_format > 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;" > > Thanks! > > Dave G. > > -- > Rewards and punishments are the lowest form of education. > -Chuang-Tzu, philosopher (4th c. BCE) > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
