timestamp-to-date broken in current sources 
Author Message
 timestamp-to-date broken in current sources
With CVS tip (and float-type timestamps) I get

regression=# select date('2002-02-01 00:00:00'::timestamp);
    date
------------
 2000-01-01
(1 row)

Seems to be the same result no matter what timestamp is put in.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.***.com/



Fri, 05 Nov 2004 23:33:17 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Is Timestamp data type really the current date

2. Retrieving most 3 current dates from timestamp

3. create a table with default timestamp as current timestamp + 100 days

4. ((Current Date - Start Date)/(End Date - Start Date))*Contract Amt

5. Current date without current time

6. java.sql.Date, Time, and TimeStamp with Oracle date type

7. Julian Date to Date-Timestamp

8. DATEADD() source (Date funciton source in General)

9. Q:get current date and then create date range

10. SQL Subtracting current date from another date

11. Fill a date field with the current date when a checkbox is checked

12. set a date dimension to current date


 
Powered by phpBB® Forum Software