SQL problem

[Ruslan Zasukhin]

On 12/06/20 7:28 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?  

Yes. MacOS have such format also.

> 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.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]