Archive for the ‘ Belajar SQL Statement ’ Category
Belajar SQL Statement – How to substract one date
How to substract one date from another date.
SELECT (TO_DATE(‘09-AUG-2003′) – TO_DATE(‘09-JUL-2003′)) as myDate
FROM dual
Result :
myDate
——
31