FAQ

On Friday 27 June 2003 00:47, Holger Marzen wrote:
In 7.1.3 I can use

select timestamp(date '2001-01-01', time '00:00');

but in 7.2.4 I get

db1=# select timestamp(date '2001-01-01', time '00:00');
ERROR: parser: parse error at or near "date"
changed in 7.2, see:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=release-7-2.html

"The timestamp(), time(), and interval() functions are no longer available.
Instead of timestamp(), use timestamp 'string' or CAST. "

-> something like:
select timestamp '2001-01-01 00:00';
should work


Ian Barwick
barwick@gmx.net

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJun 26, '03 at 10:50p
activeJun 26, '03 at 11:12p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase