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***
If your application server is running on GMT, if you try to save the date 26092016, it will convert your time zone accoding to application server time zone and save it in to the date time property in the data base.
Some times you will see that the day will also change depending on the conversion. Better to change the database property.
If you badly need to change the timestamp, on saving the data to table, explicitly you need to override the value.