Re: Problem working with dates and times.

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(at)iol(dot)ie
----------------------------------------------------------------------