Java bro

Java tutorial

Sql queries

Get today 12:00 PM timestamp in sql

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

Theme by Anders Norén