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@xxxxxx ----------------------------------------------------------------------
