Dan McGhan on Dates, Timestamps and Timezones
It can be tricky sorting out which datatype to use:
DATE?
TIMESTAMP?
TIMESTAMP WITH TIMEZONE?
TIMESTAMP WITH LOCAL TIMEZONE?
Dan McGhan, Developer Advocate at Oracle, offers this quick review and recommendation (hint: local timezone). For lots more information about working with dates in Oracle Database, and doing so from multiple languages: https://jsao.io/2016/08/working-with-...