How to get day of date in iob level

Hi,
 
I want to display the day of current date in iob level. But we doesn't have day() function in iob level function.
 
In report design we have the function. But as per my requirment we should use in iob itself. 
 
How can we get that?
 
--
Thanks & Regards,
Gopi

Find more posts tagged with

Comments

JFreeman

I'm not clear on exactly what you are asking.
Can you please provide more details on your use case and what you are wanting to accomplish?

pricher

Hi,
 
Have you tried the DATEPART function? To return the day of the SHIPBYDATE, you would use it this way:
 
DATEPART('d', SHIPBYDATE)
 
Hope this helps,
 
P.

gopi.inampudi

Hi
 
by using the DATEPART function its returning the DATE.
 
Example: DATEPART('07/09/2015',SHIPBYDATE) --> 07
But here i am lokking for instead of 07 it should return Thursday.
 
report level we have Day() function. But in iob level this function is not working. Then i should i achieve it.
 
Please suggest.

JFreeman

The exact syntax will vary depending on the data base type you are using.
With PostgreSQL, this can be achieved using 'Day' with the to_char function.
 
For example:
<pre class="_prettyXprint _lang-sql">
Select to_char(public.sampletable.datecol, 'Day')
from public.sampletable</pre>
Output:
<pre class="_prettyXprint _lang-nocode">
Friday
</pre>