top of page

Display time in a Date column

By default, when you query a date column, oracle will only display dates and not time. Below query enables Oracle to display both date and time for a particular session

alter session set nls_date_format='dd-Mon-yyyy hh:mi:sspm';

Note: this is only session level query.

Related Posts

Heading 2

Add paragraph text. Click “Edit Text” to customize this theme across your site. You can update and reuse text themes.

bottom of page