Oracle EBS Technique Sharing

Thursday, December 3, 2020

Last day, last time

 

select last_day(add_months(sysdate,-1)) from dual;
select last_day(add_months(trunc(sysdate+1)- INTERVAL '1' SECOND,-1)) from dual;

SELECT TRUNC(SYSDATE + 1) - 1/(24*60*60) FROM DUAL
SELECT TRUNC(SYSDATE + 1) - INTERVAL '1' SECOND FROM DUAL;
Posted by Finch Chen at 6:07 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Finch Chen
View my complete profile

Blog Archive

  • ►  2022 (5)
    • ►  September (1)
    • ►  May (1)
    • ►  March (3)
  • ►  2021 (4)
    • ►  April (1)
    • ►  January (3)
  • ▼  2020 (12)
    • ▼  December (6)
      • EBS structure level difference for R11 & R12
      • Cost - Periodic Actual Cost Worker CSTPPINV.COST_I...
      • Tablespace Check
      • Last day, last time
      • Cost related tables - Include PAC
      • Oracle Tables information website - eTRM - Technic...
    • ►  November (1)
    • ►  October (2)
    • ►  May (2)
    • ►  January (1)
  • ►  2019 (13)
    • ►  November (1)
    • ►  October (4)
    • ►  September (1)
    • ►  July (3)
    • ►  June (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2018 (35)
    • ►  December (3)
    • ►  November (9)
    • ►  October (2)
    • ►  September (3)
    • ►  August (6)
    • ►  July (4)
    • ►  June (8)
Awesome Inc. theme. Powered by Blogger.