Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Next_day function to HiRDB

HiRDB database supports Next_day function. SQLWays leaves it as is.

Oracle:

select next_day(CURRENT_DATE, 'Sunday'),
next_day(CURRENT_DATE, 'monday'),
next_day(CURRENT_DATE, 'Tuesday'),
next_day(CURRENT_DATE, 'Wednesday'),
next_day(CURRENT_DATE, 'Thursday'),
next_day(CURRENT_DATE, 'Friday'),
next_day(CURRENT_DATE, 'Saturday') from t;

HiRDB:

select next_day(CURRENT_DATE,1),
next_day(CURRENT_DATE,2),
next_day(CURRENT_DATE,3),
next_day(CURRENT_DATE,4),
next_day(CURRENT_DATE,5),
next_day(CURRENT_DATE,6),
next_day(CURRENT_DATE,7) from t;

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.