DB version:11.2
I don't want the seconds component not to be printed in the output. ie. 53 shown in red below.
Of course, I can remove SS from NLS_DATE_FORMAT setting to achieve this. But, I need a way to suppress the seconds component at the SELECT level. Like ROUND or TRUNC... etc
SQL> alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
SQL>
SQL> select (sysdate-240/1440) from dual;
(SYSDATE-240/1440)
-------------------
10-07-2014 13:12:53
SQL>
Expected output
-------------------
10-07-2014 13:12