on 03-04-2015 8:07 AM
Hello,
JDBC – to –proxy interface, we need to pick the data using select
* from <table>.
As the data is very huge we want to pick current year and
previous year data from table.
Date format is 1-Jan-2015, let me know how can write select
query to pick current year and previous year details from database table.
Hi Chinna,
If the database is Oracle you can use this:
WHERE fieldDate >= TO_DATE('2015-01-01', 'YYYY-MM-DD')
AND fielDdate <= TO_DATE('2015-12-31', 'YYYY-MM-DD')
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.