Start a new topic
Answered

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


Best Answer

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 Comment

Answer

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

Login to post a comment