Add DATEADD and DATEDIFF functions to PI SQL Commander

When any time related functions need to be performed against timestamp columns in PI SQL Commander, one needs to utilize a significant amount of conversions to make this work. For example, if one needs to round timestamps to the nearest minute or the nearest hour, a CASE statement with multiple CASTs needs to be done to get this to work. If T-SQL DATEADD and DATEDIFF commands were implemented, this would simplify the query by a significant amount. Similarly, in PL/SQL, the ROUND function is able to round the datetime value directly, which would fit perfectly to this scenario.

ADMIN RESPONSE

Aug 23, 2022

This feature, while useful, is not a high enough priority yet. Therefore, we are setting it to declined.

Attach files

Enter a subject

Please enter your email address

RELATED IDEAS

Add DATEADD and DATEDIFF functions to PI SQL Commander