<div>
to_char(DATE '2011-08-22','fmDay')
</div>


<div>
If I want to use this in oracle forms post query Can I add the column name here?<br />
column name is sched_date<br />
<br />
select to_char(DATE '2011-06-25','Dy') from dual
</div>


If I want to use this in oracle forms post query Can I add the column name here?
column name is sched_date

select to_char(DATE '2011-06-25','Dy') from dual

<div>
yes, use column instead of date literal<br />
<br />
and your table instead of dual
</div>


yes, use column instead of date literal

and your table instead of dual

<div>
<div class="content wysiwyg-content">
I need to get the day of the week for a given date<br />
<br />
For eg 06/25/2011 - was a saturday. So I need to get as Sat.<br />
I know there is extract function<br />
extract(YEAR FROM DATE '2011-08-22') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;would return 2011<br />
extract(MONTH FROM DATE '2011-08-22') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;would return 8<br />
extract(DAY FROM DATE '2011-08-22') &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;would return 22<br />
<br />
But I need it to return as Sat. Any help is appreciated
</div>
</div>


I need to get the day of the week for a given date

For eg 06/25/2011 - was a saturday. So I need to get as Sat.
I know there is extract function
extract(YEAR FROM DATE '2011-08-22') 	would return 2011
extract(MONTH FROM DATE '2011-08-22') 	would return 8
extract(DAY FROM DATE '2011-08-22') 	would return 22

But I need it to return as Sat. Any help is appreciated

getting day of the week from given date in oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.