db2 vs oracle part1

 


***dummy table
sysibm.sysdummy1 = dual

select current_date from sysibm.dual

cast function

CURRENT DATE= sysdate

 

first_day()

last_day()

add_days

add_months

- 1 day

-1 month

fetch first 5 rows only

limit 1000