Question

3
Replies
246
Views
Close popover
vinothkumar jayachandran (vinothkumarj)
HCL
Senior Consultant
HCL
AU
vinothkumarj Member since 2013 4 posts
HCL
Posted: September 25, 2016
Last activity: September 26, 2016
Closed

Date Issue

Hi All,

 

When I am trying to update a date field in Oracle database, I am using the function CurrentDateStamp() and formatting the date value with FormatDateTime with the default time zone as Australia/sydney..

the value in the clipboard is Date but in the database it is being updated with a time stamp as 10:00:00

 

Can anyone of you help me in removing the time zone , and update just the date in the database( so that my time stamp is always 00:00:00).

the property type is of date in pega.

***Updated by Moderator: Vidyaranjan| Included Categories***

Low-Code App Development Data Integration Java and Activities User Experience
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.