"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 BST....is 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]