From: | David Salisbury <salisbury(at)globe(dot)gov> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | timezone help? |
Date: | 2011-07-19 19:01:19 |
Message-ID: | 4E25D47F.4060406@globe.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-07-19 19:15:54 | Re: timezone help? |
Previous Message | Leif Biberg Kristensen | 2011-07-19 18:40:22 | Re: announcements regarding tools |