# \[SOLVED\] Date/TimePicker inconsistency with DB value

**URL:** <https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918>\
**Category:** Need help\
**Created:** [January 26, 2017, 2:56pm UTC](https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918 "2017-01-26T14:56:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![daxbek.julien](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@daxbek.julien](https://forum.bubble.io/u/daxbek.julien)\
**Post date:** [January 26, 2017, 2:56pm UTC](https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918/1 "2017-01-26T14:56:45Z")

</div>

Hello Bubble’s team

I have an issue with the Date/TimePicker component, the initial value value on the database is something like “Jan 26, 2017 3:42 pm” but when I display the value on a input type “Date & Time” the display shows 1/26/2017 16:00

Where am I wrong, is it a bug ? Looks like it’s because the component react like this ?  
Thanks for your help.

Regards,  
Dax.

---

<div class="post-metadata">

**Author:** ![sridharan.s](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/sridharan.s/32/17881_2.png) [@sridharan.s](https://forum.bubble.io/u/sridharan.s)\
**Post date:** [January 26, 2017, 5:34pm UTC](https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918/2 "2017-01-26T17:34:12Z")

</div>

Looks like it’s showing time in 24 hour mode (e.g., 4pm = 16:00), and you probably have it set to show time increments of 30 minutes, so it’s rounding 3:42 to 4pm.

I’m nearly certain there are toggle options for each of these within the date/time picker.

---

<div class="post-metadata">

**Author:** ![daxbek.julien](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@daxbek.julien](https://forum.bubble.io/u/daxbek.julien)\
**Post date:** [January 26, 2017, 9:17pm UTC](https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918/3 "2017-01-26T21:17:38Z")

</div>

Indeed, I miss the ‘time interval’ setup on the field.  
Now it has been set to ‘1’ instead of ‘30’

Thanks for the quick answer !

---

<div class="post-metadata">

**Author:** ![sridharan.s](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/sridharan.s/32/17881_2.png) [@sridharan.s](https://forum.bubble.io/u/sridharan.s)\
**Post date:** [January 27, 2017, 2:28am UTC](https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918/4 "2017-01-27T02:28:02Z")

</div>

You’re welcome. Glad to hear you got it working!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [April 6, 2017, 2:56pm UTC](https://forum.bubble.io/t/solved-date-timepicker-inconsistency-with-db-value/9918/5 "2017-04-06T14:56:59Z")

</div>

Closed on April 6, 2017, 2:56pm UTC

This topic was automatically closed after 70 days. New replies are no longer allowed.