at time zone question in pl/pgSQL

Поиск

Список

Период

Сортировка

От	Heather Grace
Тема	at time zone question in pl/pgSQL
Дата	14 февраля 2002 г. 12:14:20
Msg-id	008201c1b578$e0b4c1d0$1505a8c0@heatherlaptop обсуждение исходный текст
Список	pgsql-general

Дерево обсуждения

Using postgresql version 7.1

I'm trying to write a simple pl/pgsql function that will return the current time for the given time zone ( i have to deal multiple time zones) . But I don't seem to be using the appropriate syntax. I keep getting an error on the 'at time zone...'

DECLARE

new_time TIMESTAMP;

BEGIN

SELECT INTO new_time now() at time zone 'PST'; /*just hard coding the time zone for now */

return new_time;

END;

The following select statement works from an SQL query:

SELECT now() at time zone 'PST'

and returns the appropriate time.

I have also tried using the following statements:

Set TimeZone to PST;

return now();

but that didn't give me the time for PST, only the default time zone, EST.

thanks in advance,

--heather grace

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

at time zone question in pl/pgSQL