Re: [GENERAL] Use of datepart() on TimeStamp. - Mailing list pgsql-general

On Mon, 31 Jan 2000, Jose Soares wrote:

>
>
> Jeffrey Silberberg wrote:
>
> >     Using Access 97 I have a Database field defined as a time stamp being
> > pulled in as a data type of date/time which is correct.  My problem is that
> > I now what to add some criteria to select it and have tried both the
> > criteria of Date()-1 which results in an empty set, and createing a new
> > field =datepart("yymmdd", [fieldname] which results in the new column being
>
> check for datepart() syntax:
> datepart("yymmdd") returns  #Error but
> datepart("yyyy") is ok.

In next PostgreSQL version will available to_char() routines. It allow
you to use "yymmdd" date format.

                        Karel