rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 22nd, 2008

 

create or replace function get_period (pDate varchar2) return varchar2is pday varchar(20);begin SELECT TO_CHAR(to_date('&DATE','MM/DD/YYYY'),'DAY') into pday FROM DUAL;return pday;end get_period;to call the function select get_period(08/03/2008) from dual;

raghuprasad

 Profile Answers by raghuprasad Questions by raghuprasad

• Aug 25th, 2008

 

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.