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;