date sql vs dateDatime code example

Example: difference in dates sql

SELECT (END_DATE - START_DATE) Days-Total FROM MyTable
/*this works for oracle sql*/