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.
Kind regards Joe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]