• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 3085 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Data problem issues when is written on DB

miket0001

For example I have a data and time constant with 01/01/2018 00:00. When I'm trying to write it inside the database somehow my timezone is applied. I tried to set the process to database timezone, applied gmt and local function, but I don't get the value of the above constant inside DB. Any ideas? Thanks

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi Miket,
    I hope you mean Date problem and not Data problem.
    Appian stores and retrieves datetime values as if they are set in the GMT time zone. So if in Appian you have set timezone as EST, when you insert current date and time, Appian will automatically convert into GMT and store it. When you retrieve it through Appian, based on current time zone say EST, GMT date time will convert into EST.
Reply
  • 0
    Hi Miket,
    I hope you mean Date problem and not Data problem.
    Appian stores and retrieves datetime values as if they are set in the GMT time zone. So if in Appian you have set timezone as EST, when you insert current date and time, Appian will automatically convert into GMT and store it. When you retrieve it through Appian, based on current time zone say EST, GMT date time will convert into EST.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.