Java bro

Java tutorial

Sql queries

Get next week date with timestamp

In this article we wre going to learn how to get next week day and time. For example , I want to get next wednesday 11 AM.

SELECT TO_CHAR (TRUNC(NEXT_DAY(sysdate,’WEDNESDAY’))+11/24 , ‘MM-DD-YYYY HH12:MI:SS:PM’) AS NEXT_WEEK_TIME FROM DUAL;

Output :

NEXT_WEEK_TIME
03-09-2016 11:00:00:AM


Comments are Closed

Theme by Anders Norén