Re: timestamps and timezones

2004-05-12 Thread Egor Egorov
"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

timestamps and timezones

2004-05-11 Thread joe collins
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 c