On Fri, May 06, 2005 at 06:26:14PM +0530, Nageshwar Rao wrote: > > How to extract date(mm/dd/yyy) from a timestamp .
You could cast the timestamp to date. See also "Data Type Formatting Functions" and "Date/Time Functions and Operators" in the "Functions and Operators" chapter of the documentation. http://www.postgresql.org/docs/8.0/interactive/functions-formatting.html http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
