timezone help?

Поиск
Список
Период
Сортировка
От David Salisbury
Тема timezone help?
Дата
Msg-id 4E25D47F.4060406@globe.gov
обсуждение исходный текст
Ответы Re: timezone help?
Re: timezone help?
Список pgsql-general
I'm a bit new to PG, and having troubles with timestamps.  The docs list:

timestamp [ (p) ] [ without time zone ]    8 bytes    both date and time    4713 BC    5874897 AD    1 microsecond / 14
digits
timestamp [ (p) ] with time zone    8 bytes    both date and time, with time zone    4713 BC    5874897 AD    1
microsecond/ 14 digits 

But an example of how to call to_timestamp either with or without a TZ would help.



My immediate problem is below..

create or replace function get_thermom_type(siteid integer, observationtime timestamp)

select get_thermom_type(1,to_timestamp('01-JAN-2011','DD-MON-YYYY') );
ERROR:  function get_thermom_type(integer, timestamp with time zone) does not exist
LINE 1: select get_thermom_type(1,to_timestamp('01-JAN-2011','DD-MON...
                ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


How do I tell to_timestamp to forget the about time zones?  this didn't work either:

get_thermom_type(1,to_timestamp('01-JAN-2011 HH24:MI','DD-MON-YYYY 13:01') without time zone);
nor a bunch of other attempts.


Thanks for any help,

-Dave

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

Предыдущее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: announcements regarding tools
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: timezone help?