In the database table (Firebird), the field type is datetime, so the data themselves will be saved as some kind of float number.
Using string type is just for convenience in the construction of SQL texts, and conversions are done only by the system.
That's not what we meant.
Do you know the difference between 02-03-2020 and 03-02-2020?
I can tell you, Firebird doesn't !
(And halve the world will disagree with you about what's what)
Depending on the system you run this on (or the server is installed on) the date will be in februari or march. And I can guarantee you this will go wrong someday.
If you use 2020-03-02 as string, you are sure to be in march, and Firebird knows that.
So.. Never, ever use dd-mm-yyyy or mm-dd-yyyy format if you are dealing with databases.
Use yyyy-mm-dd
So... did you check what DateToStr(now) gave you back?