On Wed, 27 Mar 2002 [EMAIL PROTECTED] wrote: > Hello all. > > I'v migrated my data to 7.2. > Now I'm testing aplications, but looks like timestamp function in > postgres is broken: > klienti=# select date(now()); > date > ------------ > 2002-03-27 > (1 row) > > klienti=# select timestamp(date(now())); > ERROR: parser: parse error at or near "date" > > I need to make querys with timestamp(date,time); > But timestamp don't work even with sample from manual: > > klienti=# select timestamp(date '1998-02-24',time '23:07'); > ERROR: parser: parse error at or near "date"
timestamp is more reserved than before, I believe it'll work as "timestamp"(...). The other form is now for specifying the precision of a timestamp. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
