Re: timezone help?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, Jul 19, 2011 at 12:15:54PM -0700, Adrian Klaver wrote:
> On Tuesday, July 19, 2011 12:01:19 pm David Salisbury wrote:
> > I'm a bit new to PG, and having troubles with timestamps.  The docs list:

[...]

> > My immediate problem is below..
> >
> > create or replace function get_thermom_type(siteid integer, observationtime
> > timestamp)

[...]

> How about:
> test(5432)aklaver=>SELECT to_timestamp('01-JAN-2011','DD-MON-YYYY')::timestamp;
>     to_timestamp
> ---------------------
>  2011-01-01 00:00:00

Simply TIMESTAMP '01-JAN-2011' should work too:

 | test=# create or replace function fu(t timestamp) returns timestamp as
 | $$
 | begin
 |   return $1;
 | end $$ language plpgsql;
 | CREATE FUNCTION
 | test=# select fu(TIMESTAMP '01-JAN-2011');
 |          fu
 | ---------------------
 |  2011-01-01 00:00:00
 | (1 row)

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFOJeNvBcgs9XrR2kYRAm9yAJ9EgZ3IN9Y1WrsQ9ke4rNXVGLEF6gCeI8/L
Ii66It4LvdL/6reVNti9ZBo=
=8fUi
-----END PGP SIGNATURE-----