Navigation

    APPDRAG Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular

    REMINDER

    Please be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

    Default Timezone

    Cloud Backend (Cloud DB, API Builder)
    2
    3
    265
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Pierre SULPICE
      Pierre SULPICE last edited by

      Hello,

      When I use CURRENT_TIMESTAMP as a default value in the Databases, it's not the right Timezone.

      I tried 2 things so far :

      • SET GLOBAL time_zone in a new query, but it says I don't have enough privileges

      • CONVERT_TZ(NOW(), 'GMT', 'MET') as a default value, but I get this :
        44d989ad-2540-476a-9aed-5d8ea5f8b7b8-image.png
        It's not the first time I have this kind of error, sometimes I just refresh my page and it works, sometimes (like now) not.

      How to set the time_zone I want please 🙂 ?

      1 Reply Last reply Reply Quote 0
      • Wassim
        Wassim last edited by Wassim

        Hello Pierre,

        Default value is for "values" (string, numbers) or a restrained formulas list we manually authorized like "NOW()". You won't be able to do what you're trying.

        I suggest you to keep your dates in the default timezone (UTC) and to convert it when you select your data (with MySQL) or do a process on your frontend (JS)

        1 Reply Last reply Reply Quote 0
        • Pierre SULPICE
          Pierre SULPICE last edited by

          Ok I'll go with that, thanks !

          1 Reply Last reply Reply Quote 1
          • First post
            Last post