Board index » PostgreSQL
All times are UTC
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/
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
timestamp-to-date broken in current sources