Question
2
Replies
120
Views
Posted: July 25, 2017
Last activity: July 25, 2017
Is it possible to user functions inside a Connect-SQL rule
Hi,
I have a requirement to use Connect-SQL rule. I have to fetch the records which are resolved today. I am planning write a query using pyResolvedTimeStamp and pxCurrentDateTime. I need only the date and year part of these two properties.(Time is not required). For this is it possible to use functions in Connect-SQL query.
Thanks in advance.
Regards,
Manasa
I've seen it many times in select and from clauses. I suspect you can also do it inside a DECLARE BEGIN END in the Obj-Save of a Connect-SQL as stored procedures are often configured.