# How to display time from a date DB field

**URL:** <https://forum.bubble.io/t/how-to-display-time-from-a-date-db-field/59065>\
**Category:** Database\
**Created:** [June 11, 2019, 4:16pm UTC](https://forum.bubble.io/t/how-to-display-time-from-a-date-db-field/59065 "2019-06-11T16:16:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mtranweb](https://avatars.discourse-cdn.com/v4/letter/m/e68b1a/32.png) [@mtranweb](https://forum.bubble.io/u/mtranweb)\
**Post date:** [June 11, 2019, 4:16pm UTC](https://forum.bubble.io/t/how-to-display-time-from-a-date-db-field/59065/1 "2019-06-11T16:16:21Z")

</div>

Creating a scheduling app and I have saved available day and time in 2 fields FromDateTime and ToDateTime. I would like to display the time separate from the Date. How do I extract and display the time? I can display just the date with the FormatAs function but the only thing I see for Time is to Extract: Hours and Extract:Minutes. If I use that then I would have to do complicated formatting just to display times correctly. TIA

---

<div class="post-metadata">

**Author:** ![Jici](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jici/32/30722_2.png) [@Jici](https://forum.bubble.io/u/Jici)\
**Post date:** [June 11, 2019, 4:20pm UTC](https://forum.bubble.io/t/how-to-display-time-from-a-date-db-field/59065/2 "2019-06-11T16:20:15Z")

</div>

Date:formatted as

> **[Bubble Reference](https://bubble.io/reference#Data.Messages.date)**
>
> Full reference for each Bubble element, feature, plugin. Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

---

<div class="post-metadata">

**Author:** ![mtranweb](https://avatars.discourse-cdn.com/v4/letter/m/e68b1a/32.png) [@mtranweb](https://forum.bubble.io/u/mtranweb)\
**Post date:** [June 11, 2019, 4:23pm UTC](https://forum.bubble.io/t/how-to-display-time-from-a-date-db-field/59065/3 "2019-06-11T16:23:22Z")

</div>

Thanks so much. I completely missed on the dropdown. Arrrrggg so simple.
