Get today 12:00 PM timestamp in sql

Posted by vsreenu48 on May 2, 2020

In this article we wre going to learn how to get today at 12:00 noon time stamp.

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

Comments are Closed

Java bro