Get day of week (dow) from old date
764712May 19 2010 — edited May 19 2010Hi,
Do you know how I can get dow (Mon, Tue) from any date that stored let say in param:
bizdate date :='15-May-2010';
day3 varchar2(3);
I use that first select from dual, but can't figure out how to replace current date with another,
#1:
select to_char(sysdate,'dy') into day3 from dual;
#2:
select to_char('15-May-2010','dy') into day3 from dual;
how I can tell pl that '15-May-2010' in date format ???
Tx
T