Date Picker Runtime Analytics format is not coming in profer way

[Sunny]

Hi Team,

We are creating a runtime analytics where between startdate and enddate we were fetching task details.

however I was not able to fetch the Time format in the runtime analytics configuration while previewing it.

the below query is fetching the date format however unable to give me to select the time frame as well.
SELECT updatedate as DateOfUpdate, status as Status_of, endpoint, tasktype, taskkey, userkey FROM arstasks WHERE status = '3' AND updatedate BETWEEN DATE_FORMAT('${startDate}', "%Y-%m-%d %H:%i:%s") AND DATE_FORMAT('${endDate}', "%Y-%m-%d %H:%i:%s")

Can you please help me with?

[stalluri]

@Sunny 

SELECT
updatedate AS DateOfUpdate,
status AS Status_of,
endpoint,
tasktype,
taskkey,
userkey
FROM
arstasks
WHERE
status = '3'
AND DATE(updatedate) BETWEEN DATE(STR_TO_DATE('${startDate}', '%Y-%m-%d'))
AND DATE(STR_TO_DATE('${endDate}', '%Y-%m-%d'));


https://forums.saviynt.com/t5/identity-governance/date-format-in-analytics-report-is-throwing-error/...

[Sunny]

Hi @stalluri ,

I tried with the above query as well before posting in to the forum. however,It didnt work.

@rushikeshvartak ,

Will it come as an- enhancement in new version?

[rushikeshvartak]

You can submit idea ticket @Sunny https://ideas.saviynt.com/ideas/new

[rushikeshvartak · Accepted solution]

You can't fetch time. So update query as per date only