Posted: 2 Jun 2015 5:38 EDT Last activity: 4 Oct 2018 11:08 EDT
Default PEGA DateTime Value 19700101T000000.000 GMT ?
If DateTime property does not contain any value then PEGA is assigning default value "19700101T000000.000 GMT" while saving to DB , Is there any specific reason for setting default value ? how it is useful?
I need to store null value in DB if DateTime property does not contain any value , how can we achieve it?
+91 97911 69643
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Thank you for your query. You mention that if a DateTime property is not set, a default "19700101T000000.000 GMT" is assigned. Could you provide an example of where you have seen this with a screenshot if possible.
The minimum value which can be set for a DateTime property is 01-01-1000 000000.000. The maximum is 31-12-9999 000000.000. This can be done using the function call @(Pega-RULES:DateTime).date(1000, 01, 01).
If the property type is datetime, the values always stores time. When it has to store time, it stores in GMT format. If you want to enable user selecting hours,minutes you can do that using pxdatetime control.