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" <r...@iol.ie> To: "Bernard Barton" <bf...@comcast.net> Cc: pgsql-general@postgresql.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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
