From: | Jose Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | Jeffrey Silberberg <jsilberberg(at)mindspring(dot)com>, PGSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Use of datepart() on TimeStamp. |
Date: | 2000-02-01 13:21:46 |
Message-ID: | 3896DDEA.388986AC@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sferacarta(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak - Zakkr | 2000-02-01 13:40:23 | Re: [GENERAL] Use of datepart() on TimeStamp. |
Previous Message | Sevo Stille | 2000-02-01 12:06:37 | Re: [GENERAL] Linking in sin() as a C function |