Hi

When I use the hour of function, I see just the hour, not the day and time. See screenshot attached.

But since you want the entire time including minutes and secs, you can try writing function alias to achieve what you want. 

Here are a few helpful links to get you started.

https://community.pega.com/sites/default/files/help_v72/rule-/rule-alias-/rule-alias-function/main.htm

https://community.pega.com/video-library/support-guide-creating-and-troubleshooting-sql-function-aliases

Hope that helps.

Bhuvana

Hi Bhuvana,

You can see what the report displays from the screeshot attached. However, even if I am able to visualize only the hour, how can I visualize the minutes, also? Using a function alias is the only way?

Thanks