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!

Please Explain 1/24/3600

ricard888Aug 27 2011 — edited Aug 27 2011

Can you please explain this SQL I have been to run with 1/24/3600. what is that means in terms of the last day of the month. Thanks

      -- Revenue Recognition date within the previous month 
             AND ob.revenue_recogn_date BETWEEN (LAST_DAY (ADD_MONTHS (TRUNC (SYSDATE), -2)) + 1) 
                                            AND (LAST_DAY (ADD_MONTHS (TRUNC (SYSDATE), -1)) + 1 -1/24/3600)

This post has been answered by Solomon Yakobson on Aug 27 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2011

Added on Aug 27 2011

6 comments

2,523 views