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
C
Cédric Blanc
said
about 2 years ago
To display a timestamp with the only the date part shown like this:
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
Cédric Blanc
said
about 2 years ago
Answer
To display a timestamp with the only the date part shown like this:
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
Cédric Blanc
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
To display a timestamp with the only the date part shown like this:
What you can do is to create a field or column with the Value using this SemQL:
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
Cédric Blanc
To display a timestamp with the only the date part shown like this:
What you can do is to create a field or column with the Value using this SemQL:
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
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 252 topics