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-...
Watch video Dan McGhan on Dates, Timestamps and Timezones online, duration hours minute second in high quality that is uploaded to the channel Practically Perfect PL/SQL with Steven Feuerstein 16 January 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 2,173 times and liked it 24 visitors.