Display time in a Date column

Generally when we query a date column, it will display only  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';