Ron St.Pierre wrote:
> Example - when I run the following:
> select timestamp(date '1998-02-24',time '23:07')
> I get the following error:
> parse error at or near "date"
what you want is:
select to_timestamp('1998-02-24 23:07'::text, 'YYYY-MM-DD HH:MI');
to_timestamp
------------------------
1998-02-24 23:07:00+09
(1 row)
Have a look at:
http://www.postgresql.org/idocs/index.php?functions-formatting.html
Jc