Re: [GENERAL] Evidently no support for the mmddyyyy date format

2009-04-10 Thread bfb21
Yes, I mentioned that I could use the to_date function, but as I said, that would involve a LOT of changes to a LOT of source code, which I'm trying to avoid. -Thanks - Original Message - From: "Pavel Stehule" To: r...@iol.ie Cc: "Bernard Barton" , pgsql-general@postgresql.org

Re: [GENERAL] Evidently no support for the mmddyyyy date format

2009-04-10 Thread bfb21
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- format it works. However, the application I'm porting is all based on dates in the mmdd form