extracting date FROM timestamp

Поиск
Список
Период
Сортировка
Искать

extracting date FROM timestamp

От:
javier garcia - CEBAS <rn001@cebas.csic.es>
Дата:
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

Re: extracting date FROM timestamp

От:
Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>
Дата:
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
>

Re: extracting date FROM timestamp

От:
Pavel Stehule <stehule@kix.fsv.cvut.cz>
Дата:
Hello

tsearch2=# select extract(day from current_timestamp);
 date_part
-----------
        22

or

tsearch2=# select to_char(timestamp 'now','YY DD MM HH12:MI:SS');
      to_char
-------------------
 03 22 12 12:28:46
(1 řádka)

Regards
Pavel

On Mon, 22 Dec 2003, 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
>
FAQ