Dates don't have any inherent format -- they are converted to strings in some display format either based on the settings of your client, or your server, or through a specified date format picture.
If you want to view them in a particular format then tryCode:alter session set nls_date_format = 'dd-mon-yyyy'




Reply With Quote