Date Time attribute setting in appwrite console saves as UTC but should save as local
- 0
- Databases
- Web
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. How to handle this?
Save & Retrieve as UTC, change the difference only on the client side as per the local timezone.
thanks. yeah need to do it like this but appwrite should not be saving like this if the server time is set to local timezone.
Incase for multiple servers, UTC helps in consistent date & time.
agree but the console is not showing the utc time and I presumed that I can add my local time date. hence the confusion.
You can create a new issue with this to discuss with the community and the team
it's best practice to send and retrieve as UTC and then show as local. that's exactly what the console does
Recommended threads
- Seed db
hello there... is this correct way to seed appwrite
- Query Appwrite
Hello, I have a question regarding Queries in Appwrite. If I have a string "YYYY-MM", how can I query the $createdAt column to match this filter?
- Different appwrite IDs are getting expos...
File_URL_FORMAT= https://cloud.appwrite.io/v1/storage/buckets/[BUCKET_ID]/files/[FILE_ID]/preview?project=[PROJECT_ID] I'm trying to access files in my web app...