🚀 Feature: Change the way date time is set in console to save with local time zone instead of UTC

[gaurav-chandra]

🔖 Feature description

I have a date time field and when I use console to save the data it is saved as local time because of using HTML input type date. But when we retrieve the data, we get it in ISO format with timezone: "2023-10-03T13:49:14.723+00:00" which is UTC by default.

🎤 Pitch

Either change the way we save date time in console or add local server time zone instead of UTC otherwise we need to manipulate on the client side and in functions to local time zone.

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[Tanay-ErrorCode]

@gaurav-chandra Please assign this issue to me.

[gaurav-chandra]

@Tanay-ErrorCode I don't think I can assign this. Probably someone from the appwrite team can only assign.

[stnguyen90]

@gaurav-chandra, thanks for raising this issue! 🙏🏼

The standard behavior when working with datetimes is to send it to the server using UTC and receive it as UTC. When the client application displays it, it is shown in the local timezone. This ensures things are consistent server-side without considering what timezone the server is physically located.

I checked datatime attributes in the Appwrite Console, and it does look like this is precisely how it behaves.