Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this instance that from database, the data I will fetching is more than million of records, and in order to limit the data, I want only to load date that is equal or greater than April 1, 2012
So, this is the syntax:
Load ID,
DOCDATE,
ITEMNO;
SQL Select * from TABLE where DOCDATE >= '4/1/2012';
Is that possible? Say that I am connected to the database that is why I used SQL Select
Thanks for your help!
Regards,
Bill
Yes, that is possible. The format of the date string depends on your DBMS. Check your reference documentation for "date literal" or tell us what DBMS you are using.
-Rob
MSSQL
And the date field is in datetime format
WHERE DOCDATE >= '04-01-2012 00:00:00'
-Rob