nolan(at)celery(dot)tssi(dot)com writes:
>>> Oracle's to_date function is not lax at all.
>>
>> Then we need to fix ours. Karel?
> To make it as strict as Oracle's? I'm not entirely convinced that is a
> Good Thing.
But to_date is a different animal, because it's working from a format
string that tells it exactly which field is which. So as far as I can
see, there's no ambiguity; rather, the present behavior seems like it's
accepting demonstrably bogus data.
regards, tom lane