RE: SQL question // date_format

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

Re: SQL question // date_format

[Todd Farmer]

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]