So it is only the european setting that doesn't swap month/day? This is
getting confusing.
---------------------------------------------------------------------------
Tom Lane wrote:
> Lynna Landstreet <lynna@gallery44.org> writes:
> > Some additional information with regard to this issue, in case it helps any.
>
> Fooling around with this, I discovered that the datestyle setting *does*
> make a difference --- which is surprising considering that this
> particular date is quite non-ambiguous. (There's a big flamewar in
> progress right now on pgsql-general that presumes the present behavior
> is to accept anything that is non-ambiguous. Looks like we don't have
> all our facts straight :-()
>
> regression=# set datestyle = 'iso, us';
> SET
> regression=# select '9/19/2002'::date;
> date
> ------------
> 2002-09-19
> (1 row)
>
> regression=# set datestyle = 'iso, euro';
> SET
> regression=# select '9/19/2002'::date;
> ERROR: Bad date external representation '9/19/2002'
>
> So the answer is probably to make sure you have the US sub-mode
> selected.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
