Re: [ADMIN] Help with postgres functions

[Karel Zak]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]