Database showing offset value of date time variable

Question

I have a date time issue. In my interface a user can select a date and time. Lets use the following example: Start Date 08/04/2016 time 09:00 AM End Date is 08/30/2016 11:59 PM. When viewed in the pv this time is shown. When viewed in the DB once saved it is adding 4 hours so in the DB its 13:00 and 03:59. The calendar and internationalization are both set to UTC-05:00 Eastern Time (America/New_York. How can I get the values to save in the DB as what is entered in the interface form? Also, from the form we create a docx file that is downloadable. In these time fields they also show the +4 hours time. How do I get it to show the actually selected time. Thanks. 
 OriginalPostID-227489 
 OriginalPostID-227489

PhilB · Accepted Answer

Are you on Appian cloud? If so there's some detail on this from the latest release here: forum.appian.com/.../Appian_Release_Notes.html How are you retrieving the dateTimes from the database? Often the local() function is useful for getting the stored datetimes correct. As I understand it, the database stores in GMT but Appian should convert to and from the system locality for you, and any further user-orientated display should use local() function.