Clarity PPM: Dates Converted Differently After Migrating to PostgreSQL

book

Article ID: 195410

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Error is: Start date cannot be before finish date

Resolution

Check the custom GEL script for any date conversions.

As per the official PG documentation, https://www.postgresql.org/docs/12/functions-formatting.html
the proper function syntax needs to be used, e.g.

to_char(interval '15h 2m 12s', 'HH24:MI:SS')

Attachments