# What data type for custom field timezone offset?

**URL:** <https://forum.mautic.org/t/what-data-type-for-custom-field-timezone-offset/10506>\
**Category:** Product Support\
**Created:** [May 15, 2018, 3:01pm UTC](https://forum.mautic.org/t/what-data-type-for-custom-field-timezone-offset/10506 "2018-05-15T15:01:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bulgin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bulgin/32/1001_2.png) [@bulgin](https://forum.mautic.org/u/bulgin)\
**Post date:** [May 15, 2018, 3:01pm UTC](https://forum.mautic.org/t/what-data-type-for-custom-field-timezone-offset/10506/1 "2018-05-15T15:01:13Z")

</div>

What data type works for custom field that would use timezone offset? I’ve tried all of them and the most I get is the 3 string indicator “420” for timezone offset.

---

<div class="post-metadata">

**Author:** ![bulgin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bulgin/32/1001_2.png) [@bulgin](https://forum.mautic.org/u/bulgin)\
**Post date:** [May 16, 2018, 5:31pm UTC](https://forum.mautic.org/t/what-data-type-for-custom-field-timezone-offset/10506/2 "2018-05-16T17:31:44Z")

</div>

Thanks for that I figured that out only 30 minutes ago. The other issue is the date and time stamps.

I changed the date and time format to: Y-n-d G:i:s for all date/time fields in the configuration and finally I’m able to see the time in 24 hour format, but the hour seconds and minutes are still coming out as 00:00:00 even though _they exist_ in the backend MySQL database.

I also noticed the referring URL exists in the backend database but it never shows in reports.

So what’s up with that?

Thank you