"joe collins" <[EMAIL PROTECTED]> wrote:
> I see that
> LOCALTIMESTAMP and LOCALTIMESTAMP() are synonyms for NOW()
> when I use now() I get the database time but
> I have a webhost based in US (Pacific Time), however most database events
> will be generated from BST and this is the time zone I want to use to
> populate audit trail tables etc. I could programmatically compensate the US
> time zone by adding the hours to make up the BSTis there any neater way
> of doing this, as this solution would involve some hard coding.
Use DATE_ADD()/DATE_SUB() functions:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]