Commencer un nouveau sujet
Répondu

Display the date part of the CreateDate

Hi, trying to convert the internal CreateDate attribute to just its date part but struggling to find the correct built in function to do this. Backend is PostgreSQL


Meilleure réponse

To display a timestamp with the only the date part shown like this:

Date Part Only
Date Part Only

What you can do is to create a field or column with the Value using this SemQL:

TO_CHAR(CreationDate, 'DD Mon YYYY')

As it's now converted to a character, don't forget to set the 'Component Type' to Text and the 'Default Value Data Type' to String

1 commentaire

Réponse

To display a timestamp with the only the date part shown like this:

Date Part Only
Date Part Only

What you can do is to create a field or column with the Value using this SemQL:

TO_CHAR(CreationDate, 'DD Mon YYYY')

As it's now converted to a character, don't forget to set the 'Component Type' to Text and the 'Default Value Data Type' to String

Connexion pour poster un commentaire