OilSheikh Posted January 5, 2009 Share Posted January 5, 2009 It's been a long time sicne I cam here. Well, I finished my degree and went the tech support road rather than the Programming road for work. But, I m now back in uni and am once again doomed! I need some help with SQL. Help would be much appreciated. Please tell me on how to fix the incorrect code I have. 1. A script that asks for two hire dates and enables finding employees between them. ( Yes, I already have a table! ) Output required: EMPLOYEES HIRE DATE __________ ________ Empname, job date PROMPT Enter First Date ACCEPT a DATE PROMPT Enter Second Date ACCEPT b DATE SELECT ENAME, JOB, HIREDATE FROM EMP WHERE HIREDATE BETWEEN a AND b COLUMN ENAME HEADING Employees COLUMN ENAME FORMAT ENAME, JOB Quote Link to comment Share on other sites More sharing options...
Mark Baker Posted January 5, 2009 Share Posted January 5, 2009 WHERE HIREDATE BETWEEN TO_DATE('<date_format_mask>',a) AND TO_DATE('<date_format_mask>',b) Quote Link to comment Share on other sites More sharing options...
OilSheikh Posted January 7, 2009 Author Share Posted January 7, 2009 Thanks. Sort of helped. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.