Re: Timezone query similiar to pgsql

2005-09-09 Thread Dan Nelson
In the last episode (Sep 10), Terence said: > Does MySQL have something similiar to > > SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific'; > > I need to handle the timestamp in the database. Previous posts and some > googling suggests it should be in the PHP layer which is not

Timezone query similiar to pgsql

2005-09-09 Thread Terence
Hi List, Does MySQL have something similiar to SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific'; I need to handle the timestamp in the database. Previous posts and some googling suggests it should be in the PHP layer which is not an option for me. My users come from vario