How to take DATE as user input in PL/SQL block?

Questions by NIKKI_PRIYAL

Showing Answers 1 - 2 of 2 Answers

Inputting the date in PL/SQL is same as in SQL. Simply pass the date as a string in the format DD-MON-YYYY.

Eg: SELECT * FROM TABLE WHERE HIRE_DATE='dd-mon-yyyy'.

Or

You can also use Date functions TO_DATE('25-aug-2008','......date formate......');

Hope this is the answer, you are looking for.

Raghu.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions