Postgres Pro
Downloads
Home   >   mailing lists

extracting date FROM timestamp - Mailing list pgsql-general

From javier garcia - CEBAS
Subject extracting date FROM timestamp
Date
Msg-id 200312221117.hBMBHlr11767@natura.cebas.csic.es
Whole thread Raw
Responses Re: extracting date FROM timestamp
Re: extracting date FROM timestamp
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: questions about tsearch2 (for czech language)
Next
From: Pavel Stehule
Date:
Subject: Re: questions about tsearch2 (for czech language)