- bf...@comcast.net wrote:
> 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 i
Pavel Stehule wrote:
> 2009/4/10 :
> > 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.
> >
>
> other solution is custom datatype. It isn't too much work, but it is
> coding in C.
el Stehule
> -Thanks
>
>
>
> - Original Message -
> From: "Pavel Stehule"
> To: r...@iol.ie
> Cc: "Bernard Barton" , pgsql-general@postgresql.org
> Sent: Friday, April 10, 2009 5:40:21 AM GMT -05:00 US/Canada Eastern
> Subject: Re: [GENE
ql-general@postgresql.org
Sent: Friday, April 10, 2009 5:40:21 AM GMT -05:00 US/Canada Eastern
Subject: Re: [GENERAL] Evidently no support for the mmdd date format
Hello
use to_date function, please.
postgres=# select to_date('10122008','DDMM');
to_date
-
From: "Raymond O'Donnell"
To: "Bernard Barton"
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 mmdd date format
On 09/04/2009 23:56, Bernard Barton wrote:
Hello
use to_date function, please.
postgres=# select to_date('10122008','DDMM');
to_date
2008-12-10
(1 row)
Time: 1,152 ms
postgres=#
regards
Pavel Stehule
2009/4/10 Raymond O'Donnell :
> On 09/04/2009 23:56, Bernard Barton wrote:
>> Today I tried every permutation of the
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 mmdd. I
> tried
How exactly are you sending these values to the database? Straight SQL,
or some other mech
Bernard Barton writes:
> 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 mmdd. I
> tried
> setting this in the postgresql.conf file, and also in psql using "set
> datestyle
> to
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 mmdd. I tried
setting this in the postgresql.conf file, and also in psql using "set datestyle
to
