Thread: Extracting day from date

View Single Post

  #2 (permalink)  
Old 11-29-2008, 11:55 PM
sarunraj sarunraj is offline
Junior Member
  
Join Date: Nov 2006
Location: Bangalore, India
Posts: 16
sarunraj is on a distinguished road
Send a message via AIM to sarunraj Send a message via Yahoo to sarunraj
hi,

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

this wil work.

Arun
Reply With Quote