Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to compare dates in OBIEE reporting

723000Jul 27 2010 — edited Jul 27 2010
TRUNC(DAY_DT) = TRUNC(SYSDATE)

equalant function in OBIEE reporting.......

Regards,
sp

Comments

677579
can you explain what ur requirement is?

regards,
Roy.
kart
MAY BE

TRUNC(DATE) = TRUNC(CURRENT_DATE).

Replace sysdate with current date.
723000
There is no trunc function in obiee reporting side right?
773876
hi user11868791

try with the "case when" like:

case when DAY_DT = SYSDATE then "your task" end

Regards
SAP

Edited by: SAP on Jul 27, 2010 3:11 AM
kart
if it is not there then use with evaluate function. eg. evaluate('trun(%1)' as char, date)
723000
27/07/2010 03:37:45:55 = 27/07/2010 00:00:00:00

for the above date's i want to trunc minutes and seconds in OBIEE
Vinodh NK
Try this,

Cast(DAY_DT as DATE) = Cast(Current_Date as DATE)

Make the date type as Date.

Thanks,
Vino
SaichandVaranasi
.....
daan bakboord
Hi,

Try; TimestampDiff (interval, timestamp-expression1, timestamp-expression2)

You could use the following intervals;

SQL_TSI_SECOND
SQL_TSI_MINUTE
SQL_TSI_HOUR
SQL_TSI_DAY
SQL_TSI_WEEK
SQL_TSI_MONTH
SQL_TSI_QUARTER
SQL_TSI_YEAR

Good Luck,

Daan Bakboord
http://obibb.wordpress.com
Kishore Guggilla
cast(column as date) is correct... one.
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 24 2010
Added on Jul 27 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
10 comments
5,142 views