Groovy web console

subscribe to the feed Subscribe
to this
site

where clause in compound employee

Published 3 months ago by imran
Actions  ➤ Edit in console Back to console Show/hide line numbers View recent scripts

String CurrentDate="27-12-2019"
String lsrdtForODataQuery="26-12-2019T10:10:10"

String str="WHERE start_date <= to_datetime('" + CurrentDate.toString()+ "') && start_date > to_datetime('" + lsrdtForODataQuery.toString().substring(0,10) + "')"