Just a reminder of how to show time from a date datatype.

We all know how to strip the time off of a date by using the following command:

SELECT trunc(sysdate) from dual;

But the following takes just the time from the date variable

SELECT to_Char(sysdate,’HH:MI:SS’) from dual

How to get time from a date
Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *

1 + one =