# Issues with record create\_date and write\_date

**URL:** <https://discuss.tryton.org/t/issues-with-record-create-date-and-write-date/3873>\
**Category:** Developer\
**Created:** [March 2, 2021, 5:04am UTC](https://discuss.tryton.org/t/issues-with-record-create-date-and-write-date/3873 "2021-03-02T05:04:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fxaviergb](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/fxaviergb/32/484_2.png) [@fxaviergb](https://discuss.tryton.org/u/fxaviergb)\
**Post date:** [March 2, 2021, 5:04am UTC](https://discuss.tryton.org/t/issues-with-record-create-date-and-write-date/3873/1 "2021-03-02T05:04:40Z")

</div>

Hello everyone.  
I am having the following problem: I created a record on 2021-03-01 23:53:05 but in the database the “create\_date” field is stored with the date 2021-03-02 04:53:05. The same offset happens when I modify a record (“write\_date” field). Why is this happening?

Postscript: my OS is configured with the UTC -05 timezone (Guayaquil, Ecuador) and the database shows the “America / Guayaquil” timezone. In Tryton, my company’s Time Zone is set to “America / Guayaquil”.

---

<div class="post-metadata">

**Author:** ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)\
**Post date:** [March 2, 2021, 7:13am UTC](https://discuss.tryton.org/t/issues-with-record-create-date-and-write-date/3873/2 "2021-03-02T07:13:02Z")

</div>

This is the expected behaviour because Tryton stores datetimes using UTC timezone on server side.

Then the clients display the date using the user Timezone. If you check on the tryton client you will see that the date is correctly shown.

Even for reports we have a `format_datetime` function which converts the datetime to a timezone.

This feature allows to always show the correct time on all of the timezones and makes the system usable for users of different timezones in the same database.