• For displaying dates, or setting a date column or variable from a string literal, I've always preferred YYYY-MM-DD format.  It's unambiguous and sorts nicely.  I believe the format with DD-MON-YYYY such as 16-Jan-2019 is the Oracle default format for displaying dates, but I always found that awkward.