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.