Oracle has a website with conversion functions for translating the Oracle DATE type to UNIX epoch time. Note that I have adjusted the min/max times, the lower limit to results above, and the upper ...

DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function.