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