Re: Date function

[Benoît Minisini <benoit.minisini@xxxxxxxxxxxxxxxx>]

Le 05/11/2025 à 18:15, Jussi Lahtinen a écrit :
> Gambas date & time types and functions are really unnecessarily 
> unintuitive.
> There really should be types and functions that act like a good old 
> paper calendar. IE it is what you see, zero confusion.
>
>
> Jussi

One say that because of the confusion an actual date (see that a string 
representation) and a timestamp.

Gambas "Date" are timestamp. It has been called "Date" because of Visual 
Basic and other similar languages, but it is not a date. It should have 
been called "Timestamp".

You have the exact same problem in every SQL database systems that had 
to add new datatypes and functions among their different versions.

I took the time to explain that problem in the wiki: Date (i.e. 
timestamp) string representation without explicit timezone are like 
strings without explicit charset. The interpreter has to choose a timezone.

If you think that date representation can be intuitive, you don't study 
the subject enough.

Regards,

--
Benoît Minisini.