SQL problem

[Charles Yeomans]

On Dec 20, 2006, at 12:11 PM, Ruslan Zasukhin wrote:

> On 12/06/20 6:54 PM, "Charles Yeomans" <charles at declareSub.com> wrote:
>
>>> In SQL92 standard it is strictly 'YYYY-MM-DD'
>>> Right.
>>>
>>> So if we do this strictly this format, then we start ignore our own
>>> db.DateTimeFormat settings (which often mirror SYSTEM settings).
>>
>> It seems possible to me to handle either format in SQL statements.
>
> Not agree.
>
> How you will differ MM-DD-YYYY from DD-MM-YYYY ?


SQL is YYYY-MM-DD HH:MM:SS.  Is there a system setting that uses YYYY- 
DD-MM?  If so, then I see the problem.  And, okay, I see that it is  
simpler to insist on a single date format for the database.

Charles Yeomans