timestamp function in 7.2 
Author Message
 timestamp function in 7.2

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"

Mark

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 19 Sep 2004 03:01:13 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. 7.2 and current timestamp bug?

2. timestamp in 7.2

3. timestamp in 7.1 vs 7.2

4. Display of TIMESTAMP in 7.2

5. upper/lower function error in Informix SQL 7.2

6. Famous Bughunter Report: Bug in functions in 7.2 Fix 7

7. external function proposal for 7.2

8. How should I call Personal Oracle 7.2 stored procedure (or function)

9. 7.2 date/time format function problems

10. Problems with the lower() and upper() functions and umlaut chars in 7.2

11. Regression Test Failure on PG 7.2 under RH 7.2

12. Redhat 7.2 and D3/Linux 7.2


 
Powered by phpBB® Forum Software