Back
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.