On Wed, 2006-01-18 at 12:00, Bob Pawley wrote:
> Hi Folks
>
> I have a column for date which defaults to the ambigous 2005-1-1
> format.
>
> The documantation indicates how to change this to the unambigous Jan 1
> 2005, but the instructions aren't clear to me.
Actually, if the year comes first, it is not ambiguous. It will always
be month-day if the year comes first. It's the
mm/dd/yyyy or dd/mm/yyyy that is the issue.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
