Discussion
CapitalOne
US
Last activity: 4 Oct 2018 11:08 EDT
Default PEGA DateTime Value 19700101T000000.000 GMT ?
Hi,
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?
Thanks
Sudeerkumar Munaga
Proprietary information hidden
**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.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Pegasystems Inc.
GB
Hello,
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).
Regards,
Andrew Fontenelle
PDN Support Team
Accenture
IN
Hi Fonta,
This is happening by default, in activity - have property set and to a Date time property - if ur assigning blank, then it will set "19700101T000000.000 GMT" this value.
Thanks,
Padmanabhan K
CapitalOne
US
Hi Padmanabhan,
Is there any specific reason for it ? is there any option to avoid setting default value?
Thanks
Sudeerkumar Munaga
Synechron
IN
In UI where i am using pxdatetime as control, and i am selecting date from calendar, from where the timestamp get added to the value.
Like for example in calender i am setting Jan 01, 2015, so in the property i can see value like 20150101T040000.000GMT.
So from where this "T040000.000 GMT " is getting add. And if i want to customize the timestamp like "T120000.00GMT"
Pegasystems Inc.
JP
use "property-remove" instead of using "property-set" to set a blank value for a DateTime property if you want it to be null.
Capgemini India PVT Ltd
IN
Thanks Hong. Property-remove worked.
Areteans Technology
IN
Hello RaunakJ6,
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.
Thanks,
Ashok
Pegasystems Inc.
JP
To avoid default epoch time for datetime properties, you can try below dynamic system settings.
To avoid default epoch time for datetime properties, you can try below dynamic system settings.
Name |
Purpose |
disableEpochDateTime/ Pega-IntegrationEngine |
When a datetime property is set and the value is empty, it will by default return the epoch datetime (01-jan-1970). Set this value to "true" to have the property return no value. |
optum
US
Hi Hong,so which property did you say to set it to true? and how do I find where this default date is setting and can I remove the default date value?
Thanks
Kamala
Synechron
IN
Thank You
Wipro Ltd
IN
HI ,
How to Convert 20150801 Date format to 20150801T050000.000 GMT format??
Process 360
IN
You can make use of @(Pega-RULES:DateTime).addToDate("20150801", 0,5, 0, 0)
Synechron
IN
Thanks Ramya. That was useful
Cognizant
US
Hello Chunzhi_Hong ,
Can you please provide bit more details how can we avoid default epoch time for datetime properties.
we are using PEGA 5.3 version we have the same issue with dafault date time.
Thanks in Advance!!