Archive for the ‘ Tutorial 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
Tutorial SQL Statement – Select Statement – Part 2
The format is
SELECT field_name FROM table_name
Or you can use * for any field_name
SELECT * from table_name