On 4 Dec 2006 at 20:13, Alejandro Michelin Salomon ( Adinet ) wrote:
> But i only need 2006-12-05 from the resulting timestamp.
> How to cut only the date from this timestamp?
Use date_trunc() just to lop off the time part of the timestamp:
http://www.postgresql.org/docs/8.2/static/functions-
datetime.html#FUNCTIONS-DATETIME-TRUNC
Alternatively, use to_char() to format the output exactly as you'd
like it:
http://www.postgresql.org/docs/8.2/static/functions-formatting.html
--Ray.
----------------------------------------------------------------------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod@iol.ie
----------------------------------------------------------------------