RE: SQL question // date_format

2003-09-29 Thread Bob Showalter
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. > > "

Re: SQL question // date_format

2003-09-28 Thread Todd Farmer
m: "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, > bec

SQL question // date_format

2003-09-27 Thread David Gilden
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, '