Date Picker in Report Query

Hi All.

I am using following query to fetch data from Postgres

SELECT * FROM Func1('archivevalueTable',ARRAY[${TagName}],'2017-09-06 10:00:00','2017-09-06 18:00:00')
where timetest1>=${StartTime} and timetest1<=${EndTime}

For Tags I am able to pass required info.

But For time i.e. providing StartTime and EndTime I am not getting any data

My parameter details for StartTime and EndTime as follows

Name: - StartTime(EndTime)
Value Type:- Timestamp
Data Format:- yyyy-MM-dd hh:mm:sss
DisplayTime :- Datapicker
Query:-datanew
value:-timetest1

Please find attached
image

Code:

---

Attachment 19213

---

of time on report.
where my following hard coded query works fine for me.

SELECT * FROM Func1('archivevalueTable',ARRAY['Para1','Para2','Para3'],
'2017-09-06 04:00:00','2017-09-09 21:00:00' ) where timetest1>='2017-09-06 14:00:00' and timetest1<='2017-09-09 21:00:00'


Query Require time to be sent in format :- '2017-09-06 14:00:00'

and I get the data as..

Para1	5.99	06-09-2017 14:00:00
Para2	5.6	06-09-2017 14:00:00
Para3	7.6	06-09-2017 14:00:00
Para1	6.3	06-09-2017 14:15:15
Para2	6.2	06-09-2017 14:15:15
Paar3	8.22	06-09-2017 14:15:15

Please Support

Regards