Re: extracting date FROM timestamp

Javier,

Try casting, like so:
select current_timestamp::date;
(note, pgsql won't be able to use an index for a casted field)

Best regards,

Arjen

javier garcia - CEBAS wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>