How to extract date(mm/dd/yyy) from a timestamp .
See chapter 9.8. Data Type Formatting Functions, all about to_char()
If you just want your preset format you can use SELECT now()::date;
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
