SQL & PL/SQL

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!

Trunc (date) is taking too much time

oracle.beginnerMar 30 2016 — edited Mar 30 2016

Hello Everyone,

I want last one day data from AR Tables

SELECT ord_hed.HEADER_ID,order_number , ord_hed.SALESREP_ID

FROM OE_ORDER_HEADERS_ALLord_hed , RA_CUSTOMER_TRX_ALL RCT

WHERE

TO_CHAR (OOH.ORDER_NUMBER) = RCT.INTERFACE_HEADER_ATTRIBUTE1

AND RCT.INTERFACE_HEADER_CONTEXT='ORDER ENTRY'

AND TRUNC(RCT.CREATION_DATE) = TRUNC(SYSDATE-1)

Due to Trunc is taking too much time.

Creation_date is date field , however, when i query the data, it has the time too....

Please suggest me on this.

This post has been answered by Paulzip on Mar 30 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2016

Added on Mar 30 2016

4 comments

844 views