Database SQL / Scripts for '#SYSDATE'

Database SQL / Scripts for '#SYSDATE' - 3 Query/Script(s) found

Sample 1. Get all records that were created in last 10 days

Select * from TABLE_NAME where CREATED_DATE_COLUMN >= SYSDATE - 10

_{Like Feedback select SQL SYSDATE Date greater than}

Sample 2. Update all records / rows of a Date column to System Date

UPDATE TABLE_NAME SET COLUMN_NAME = SYSDATE;

_{Like Feedback Update Update Statement DML SysDate}

Sample 3. Get all records having date since a particular date

select * from EMPLOYEE where JOINING_DATE between to_date('01-MAY-14', 'DD-MON-YY') and SYSDATE

_{Like Feedback select query to_date sysdate get records between 2 dates get records for last 2 years}

Search Database SQL / Scripts