<div>
Use this <br />
<br />
SELECT YOUR_COLUMN_NAME FROM YOUR_TABLE<br />
WHERE YOUR_COLUMN_NAME &gt;&nbsp; SYSDATE - 365<br />
<br />
*Replace 365 with any amount of date you wish*
</div>


Use this

SELECT YOUR_COLUMN_NAME FROM YOUR_TABLE
WHERE YOUR_COLUMN_NAME >  SYSDATE - 365

*Replace 365 with any amount of date you wish*

<div>
My SQL took the Now() funtion. &nbsp;<br />
<br />
Unfortunately, It returned a syntax error with the using the sysdate. &nbsp;<br />
<br />
I can use the now() function but I need to be able to say go one year back. &nbsp;Unforunately, the -365 and the adddate function didn't work. &nbsp;Kindly advise
</div>


My SQL took the Now() funtion.  

Unfortunately, It returned a syntax error with the using the sysdate.  

I can use the now() function but I need to be able to say go one year back.  Unforunately, the -365 and the adddate function didn't work.  Kindly advise

<div>
yodercm,<br />
<br />
Your solution worked. &nbsp;I just had to use -1 and change the &gt;&nbsp;to &lt;. &nbsp;Thanks a lot.
</div>


yodercm,

Your solution worked.  I just had to use -1 and change the > to <.  Thanks a lot.

<div>
You're welcome. &nbsp;You might check out the SUBDATE which is exactly like ADDDATE but you won't need the minus sign :)
</div>


You're welcome.  You might check out the SUBDATE which is exactly like ADDDATE but you won't need the minus sign :)

<div>
<div class="content wysiwyg-content">
I have a column which has date/time. &nbsp;I want to the query to only show records in the past year from the date run (using something similar to getdate in MS SQL). &nbsp;I am using MY SQL, but I think it will be similar to (if not the same as Oracle). &nbsp;Thanks.
</div>
</div>


I have a column which has date/time.  I want to the query to only show records in the past year from the date run (using something similar to getdate in MS SQL).  I am using MY SQL, but I think it will be similar to (if not the same as Oracle).  Thanks.

Today's date filter- Oracle (My SQL)

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.