Oracle หาจำนวนวันจาก 2 date Turn Back
2016-09-23 12:59:29
Oracle two dates differance (Buddhist year)
SELECT to_date('29/09/2559', 'DD/MM/YYYY') -to_date('25/09/2559', 'DD/MM/YYYY') FROM dual;
Test result on Toad for Oracle
TO_DATE('29/09/2559','DD/MM/YYYY')-TO_DATE('25/09/2559','DD/MM/YYYY')---------------------------------------------------------------------41 row selected.