Re: [GENERAL] Use of datepart() on TimeStamp.

Karel Zak - Zakkr wrote:

> 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
>
> ************

I suppose do you refer to PostgreSQL date_part() function, while datepart() is a
M$Access function.

--
Jose' Soares
Bologna, Italy                     Jose@sferacarta.com