Question
IT
Posted: 20 hours 38 minutes ago
Last activity: 16 hours 32 minutes ago
Last activity: 29 Apr 2025 12:00 EDT
Query runner Trunc Data
Hi I don't know where to put this question of mine. I need to make a query via instant query by executing a trunc of a date but via trunc or trunc_date etc it tells me that it is an unrecognized argument type this is the query that I should develop select * FROM pc_so_work where pxcreatedatetime>trunc_date (current_date) Can you help me? Thanks
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Posted: 10 hours ago
Updated: 10 hours ago
Updated: 29 Apr 2025 12:00 EDT
Tata Consultancy Services
Tata Consultancy Services
IN
You can use Pega Query Runner from --> Configure > System > Database > Query Runner.
To access these tools, you must have the PegaRULES:DatabaseAdministrator role in your access group.
you can use below query too
select * from {CLASS:YourClassName} where pxcreatedatetime > DATE_TRUNC('minute', TIMESTAMP '2025-04-29');
or
select * from TableName where pxcreatedatetime > DATE_TRUNC('minute', TIMESTAMP '2025-04-29');
or
select * from TableName where pxcreatedatetime > DATE_TRUNC('day', TIMESTAMP '2025-04-29');
I hope this will help you
Thanks,
Ashok