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
![](https://static.wixstatic.com/media/baac51_121a663408ad477dacbfbd49d274712e~mv2.jpg/v1/fill/w_147,h_98,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/baac51_121a663408ad477dacbfbd49d274712e~mv2.jpg)
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