From: | bfb21(at)comcast(dot)net |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Evidently no support for the mmddyyyy date format |
Date: | 2009-04-10 14:24:59 |
Message-ID: | 1687977608.7631239373499637.JavaMail.root@sz0009a.westchester.pa.mail.comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This is embedded SQL in a .pgc file. You can see the "c_docket_date between :date1 and :date2" line in the select statement, which is where the dates are porcessed. If I pass a date in the mm-dd-yyyy format it works. However, the application I'm porting is all based on dates in the mmddyyyy format.
I'm 99% cerain that PostgreSQL will NOT support dates in the mmddyyyy format, unless you use the to_date function, which I'm trying to avoid.
select
c_jnum_prefix, c_jnum_seq, c_jnum_year, c_jnum_suffix, c_jnum_venue
,c_actkey, c_disp_cd
into
:prfx, :seq, :yr, :sfx, :ven, :actkey, :disp
from
c_records
where
c_jnum_prefix = :prfx
and
c_jnum_seq between :seq1 and :seq2
and
c_jnum_venue = :ven
and
c_docket_date between :date1 and :date2
order by
c_jnum_prefix,c_jnum_seq,c_jnum_year,
c_jnum_suffix,c_jnum_venue;
----- Original Message -----
From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: "Bernard Barton" <bfb21(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Sent: Friday, April 10, 2009 5:31:45 AM GMT -05:00 US/Canada Eastern
Subject: Re: [GENERAL] Evidently no support for the mmddyyyy date format
On 09/04/2009 23:56, Bernard Barton wrote:
> Today I tried every permutation of the DateStyle parameter I could find, and
> still cannot get PostgreSQL 8.3 to accept dates in the format mmddyyyy. I tried
How exactly are you sending these values to the database? Straight SQL,
or some other mechanism? Can you show us some examples?
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2009-04-10 14:33:59 | Re: Evidently no support for the mmddyyyy date format |
Previous Message | bfb21 | 2009-04-10 14:19:36 | Re: Evidently no support for the mmddyyyy date format |