| From: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Jose Soares <jose(at)sferacarta(dot)com> |
| 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-01-31 15:22:49 |
| Message-ID: | Pine.LNX.3.96.1000131161841.21328C-100000@ara.zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-01-31 15:52:35 | Re: [HACKERS] float4 confused as int?? |
| Previous Message | Jose Soares | 2000-01-31 14:34:34 | Re: [GENERAL] Use of datepart() on TimeStamp. |