Timezone Divergence Between Stored Data & Console Display

Appwrite stores datetime values in UTC (which makes sense), but the console displays them in the local timezone (UTC+1). This creates confusion since the console should reflect the actual stored values, just like querying the database directly. I also noticed this confusion in the Function execution time when using Delayed executions.

Fetched data:

TypeScript

{
  response: [
    {
      userId: '67cd2...0272',
      questionKey: 'market_transactions_v1',
      response: true,
      '$id': '67ab5d...880ace',
      '$createdAt': '2025-02-11T14:22:07.953+00:00',
      '$updatedAt': '2025-02-11T14:22:07.953+00:00',
      '$permissions': [Array],
      '$databaseId': '678654...5d611',
      '$collectionId': '67e70...0992'
    }
  ]
}

Console data: (cf. screenshot)

TL;DR

Developers are facing timezone discrepancies between the stored UTC values and the local timezone displayed in the app console. The console should reflect the stored UTC values. Solution: Adjust the console to display datetime values consistently with the stored UTC values.

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support