In this article we wre going to learn how to get today midnight time stamp.
Today mid night:
Output :
Today mid night:
SELECT TO_CHAR (TRUNC(SYSDATE) , 'MM-DD-YYYY HH12:MI:SS:PM') AS CUR_TIME FROM DUAL;
Output :
CUR_TIME |
---|
03-07-2016 12:00:00:AM |