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
C
Cedric Blanc
a dit
sur un an il y a
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 commentaire
Cedric Blanc
a dit
sur un an il y a
Réponse
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
Cedric 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
Cedric 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
Voir tous les 181 sujets