AFAIK there is no default format, but if everyone else use the Text format, you should also use it. In my previous example I made a small mistake, instead of:
AFAIK there
IS a default format. The default format (both in float as in integer) on Database level should always be yyyy/mm/dd since that corresponds to both possible binary representations and can easily compute.
This has always been the case for as long as I have been involved in computing (1978) and probably long before that, because it is logic and logical.
How would one describe a date (in computing terms) otherwise? (I know that happens, but that's for morons. You are not one of them)
@ThMSmann:
There has never been an inconsistency in the theory, there have been many cases where a programmer invented wheels that are not round...
ALL SQL versions, dBase, Paradox, well, basically any database software that is well designed sticks to the above. If you meet anything else,
blame the programmer....
The format is consistent between programming languages too..... Including COBOL and FORTRAN...