Skip to main content
P
priyadharshinis746840
June 9, 2025
Question

SQL local Timezone

  • June 9, 2025
  • 5 replies
  • 0 views

I am storing the values to sql in gmt format ,when I fetch 

The data back and show it in grid Iam changing to clients timezone but it stores in db as gmt while querying and showing in grid making difference in the time

I checked separately but the issue is in sql we need to conver to local timezone and use it.Is there any way,please suggest

I'm using view to fetch data and show in front-end

    5 replies

    stefanhelzle0001
    stefanhelzle0001
    June 9, 2025

    Not sure what you want to achieve, but in this post, I describe how time works in Appian.

    https://appian.rocks/2023/02/13/working-with-time-in-appian/

    venkatrea696188
    venkatrea696188
    June 9, 2025
    I'm using view to fetch data and show in front-end

    Can you elaborate this?? Are you using query record/ entity or any SQL commands?

     By default, Appian stores time values in ++GMT in database , whenever you query it and show it in grids it will convert into user locale. you don't have to do anything

    P
    priyadharshinis746840Author
    June 10, 2025
    1. I want to calculate the no of days between two inputs of type datetime.can anyone help
    harshas2775
    harshas2775
    June 10, 2025

    use function calworkdays()

    Terms & ConditionsAccessibility statement