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:
Name:  ERR1.png
Views: 3615
Size:  3.5 KB
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