| 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: | Whole Thread | Raw Message | 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 |