Date and time conversion is hard in databases: `conversion error from string “30-12-1899″`
Posted by jpluimers on 2018/11/21
Converting string literals to to date/time/timestamp related data is always tricky in many Database environments.
Firebird is no exception, especially because sometimes it truncates a zero time portion from a date-time/timestamp.
So you can get this:
select cast('30-12-1899' as TimeStamp)
from rdb$databaseThrowing an error:
conversion error from string "30-12-1899"
And this:
select cast('30.12.1899' as TimeStamp)
from rdb$databaseReturning
CAST
30-12-1899 0:00:00
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment