It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
Course Of The Month
11 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Need to get the last day of the month (Dec 31) for 2012 not 2013?
Posted on 2014-01-17
Hello, I'm trying to get the last day of the month for the prior year 2012 instead of 2013.
Thanks
Example
select * from hsp_bkt_aging_hx
where hsp_bkt_aging_hx.aging_dat
Thanks
Example
select * from hsp_bkt_aging_hx
where hsp_bkt_aging_hx.aging_dat
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active 1 day ago
trunc(sysdate,'yyyy') -1
will return Dec 31 2013
add_months(trunc(sysdate,'
will return Dec 31 2012
you could also use
trunc(trunc(sysdate,'yyyy'
or
trunc(sysdate,'yyyy') - 1 - interval '1' year
will return Dec 31 2013
add_months(trunc(sysdate,'
will return Dec 31 2012
you could also use
trunc(trunc(sysdate,'yyyy'
or
trunc(sysdate,'yyyy') - 1 - interval '1' year
Active today
To get the last day of the year before last -
select add_months(trunc(sysdate,'
Can you provide a little more description of what you need given different current dates?
select add_months(trunc(sysdate,'
Can you provide a little more description of what you need given different current dates?
Thanks This worked!!
Since this is only an issue in January, How could I code this to look back 2 years only during January and only look back 1 year the after January?
Example
If Month = Jan aging date = last month of 2012 else
LAST_DAY(ADD_MONTHS(TRUNC(
Since this is only an issue in January, How could I code this to look back 2 years only during January and only look back 1 year the after January?
Example
If Month = Jan aging date = last month of 2012 else
LAST_DAY(ADD_MONTHS(TRUNC(
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
(CODE)
This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 17 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.