Help with postgres functions

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

Help with postgres functions

От:
Fabio Alberto Sobral <sobral@lncc.br>
Дата:
Dear Sirs,

   I have a timestamp atribute in my table and I want to get only the date of
this atribute. How can I do this? Does the extract or date_part functions 
resolve my problem?

Regards,

Fabio Sobral.

Re: Help with postgres functions

От:
Karel Zak <zakkr@zf.jcu.cz>
Дата:
On Thu, Apr 19, 2001 at 10:04:42AM -0300, Fabio Alberto Sobral wrote:
> Dear Sirs,
> 
>    I have a timestamp atribute in my table and I want to get only the date of
> this atribute. How can I do this? Does the extract or date_part functions 
> resolve my problem?

Cast timestampt to date:

        myAttr::date
or
        CAST(myAttr as date)


                                Karel
FAQ