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

Download   Rapidshare   Hotfile   Megaupload

This entry was posted on Tuesday, June 22nd, 2010 at 3:00 pm and is filed under Belajar SQL Statement, Learn SQL Statement, Tutorial SQL Statement. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply