Extracting day from date

[shaeron_56]

Hi

Is it possible to extract the day from a given date

thnx

[sarunraj]

hi,

select to_char(sysdate,'DAY') from dual;

this wil work.

Arun