timezone help?

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

Responses

Browse pgsql-general by date

  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