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.
>
> "
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
