timezone help? - Mailing list pgsql-general

From David Salisbury
Subject timezone help?
Date
Msg-id 4E25D47F.4060406@globe.gov
Whole thread Raw
Responses Re: timezone help?
Re: timezone help?
List 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 by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: announcements regarding tools
Next
From: Adrian Klaver
Date:
Subject: Re: timezone help?