Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
TO_DSINTERVAL(<date_string>,<format mask>,<NLS_PARAMETER>)-- select from the employees table all employees who -- worked for the company for at least 100 days on -- January 1, 1990:SELECT employee_id, last_name FROM employees
WHERE hire_date +TO_DSINTERVAL('100 10:00:00')<=DATE'1990-01-01';
EMPLOYEE_ID LAST_NAME
----------- ---------------100 King
101 Kochhar
200 Whalen
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.