JDBC Sender communication channel SQL query

[Former Member]

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.

[iaki_vila · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks for the update,

database is oracle and i cant hardcode the date right in production.

it should use system date, how to write the query

[naveen_chichili · Accepted solution]

Hi Chinna,

You need not hardcord the date in PRD just try to fetch the data with the dates as mentioned above.

Thanks,

Naveen