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-----