extracting date FROM timestamp

From: javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: extracting date FROM timestamp
Date: 2003-12-22 11:18:21
Message-ID: 200312221117.hBMBHlr11767@natura.cebas.csic.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi;
Please. Could you tell me the more simple way to extract the 'date' part of a
timestamp value.
I guess we could extract the year, month, and day subfields and concatenate
them. But, isn't there a more direct way?

Best regards,

Javier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2003-12-22 11:25:50 Re: questions about tsearch2 (for czech language)
Previous Message Oleg Bartunov 2003-12-22 11:05:59 Re: questions about tsearch2 (for czech language)