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
over 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
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
K
Kousik DAS
said
3 months ago
Hi,
I have a requirement as below:
I have a field with Data type as 'Timestamp'. Our inline database is SQL Server.
We have below requirements:
During Editing a record (Direct Authoring), user wants to select only date for this field (time option should not be there), and after submitting only date should be shown in that field.
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
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstCé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
Kousik DAS
Hi,
I have a requirement as below:
I have a field with Data type as 'Timestamp'. Our inline database is SQL Server.
We have below requirements:
During Editing a record (Direct Authoring), user wants to select only date for this field (time option should not be there), and after submitting only date should be shown in that field.
Please suggest.
Regards,
Kousik
-
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 276 topics