How to take last 6 month dates from the current month in oracle SQL

Question

0.00/5 (No votes)

See more:

I have a column create_date( date) in my table. It is having one year data.

I want to fetch those data, which are last 6 month data from the current date..

Example - today's date is - 3rd October, I want all the date from 3rd April.

Thanks in advance.

What I have tried:

I am still trying to find the exact solution..

Posted 2-Oct-16 21:48pm

Bittu14

Updated 3-Oct-16 0:27am

v3

Add a Solution

3 solutions

Solution 1

Try:

SQL

SELECT * FROM MyTable WHERE create_date > DATEADD(mm, -6, GETDATE())

Posted 2-Oct-16 22:00pm

OriginalGriff

Comments

Bittu14 3-Oct-16 4:13am

Dateadd function is not working in oracle SQL. It is a function of SQL server.

I have tried it before. Its seems that "DATEADD ": invalid identifier.

OriginalGriff 3-Oct-16 4:23am

If you want Oracle solutions, **then tell us it's Oracle** !
Read the documents: https://docs.oracle.com/cd/E51711_01/DR/Dateadd.html
And try that:
DateAdd(Date(), "1", , -6)

Bittu14 3-Oct-16 5:51am

Still it is not working.. :(

Solution 2

Hello

For MS SQL Server You can use:

C#

where datetime_column >= Dateadd(Month, Datediff(Month, 0, DATEADD(m, -6, current_timestamp)), 0)

hope it works
best regards

Posted 2-Oct-16 22:47pm

Ali Majed HA

Comments

Bittu14 3-Oct-16 5:44am

I want it in oracle SQL.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bittu14 · Accepted Answer · 2016-10-03T00:27:00

Solution 3

I got my Answer.

The answer is -

Select create_date from test_date where create_date > sysdate-180;

thanks for everyone's help... :)

Posted 3-Oct-16 0:27am

Bittu14