Nageshwar Rao wrote:
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)---
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 documentatio
Title: Extracting date from timestamp
How to extract date(mm/dd/yyy) from a timestamp .
