# Time only field from postgresql

**URL:** <https://forum.radzen.com/t/time-only-field-from-postgresql/7728>\
**Category:** Angular\
**Created:** [May 6, 2021, 8:47pm UTC](https://forum.radzen.com/t/time-only-field-from-postgresql/7728 "2021-05-06T20:47:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bensina](https://forum.radzen.com/user_avatar/forum.radzen.com/bensina/32/6761_2.png) [@bensina](https://forum.radzen.com/u/bensina)\
**Post date:** [May 6, 2021, 8:47pm UTC](https://forum.radzen.com/t/time-only-field-from-postgresql/7728/1 "2021-05-06T20:47:30Z")

</div>

Is there a way to display time only fields in regular-user familiar 24 hours format?

Currently, the Datagrid is displaying the field in duration format: `PT7H30M`  
While I need it to be displayed like so: `07:30`

Any suggestions with a way that doesn't involve a lot of low level code and knowledge would be appreciated.

This also needs to be set in the Form.

---

<div class="post-metadata">

**Author:** ![korchev](https://forum.radzen.com/user_avatar/forum.radzen.com/korchev/32/4_2.png) [@korchev](https://forum.radzen.com/u/korchev)\
**Post date:** [May 7, 2021, 4:48am UTC](https://forum.radzen.com/t/time-only-field-from-postgresql/7728/2 "2021-05-07T04:48:24Z")

</div>

Hi @bensina,

Radzen does not have built-in support for time-only fields.

---

<div class="post-metadata">

**Author:** ![bensina](https://forum.radzen.com/user_avatar/forum.radzen.com/bensina/32/6761_2.png) [@bensina](https://forum.radzen.com/u/bensina)\
**Post date:** [May 7, 2021, 11:10am UTC](https://forum.radzen.com/t/time-only-field-from-postgresql/7728/3 "2021-05-07T11:10:17Z")

</div>

Too bad!

Also I can not use Angular pipe to format the string as such, nor will it display just as a string with the colon between the two sets of digits.

---

<div class="post-metadata">

**Author:** ![korchev](https://forum.radzen.com/user_avatar/forum.radzen.com/korchev/32/4_2.png) [@korchev](https://forum.radzen.com/u/korchev)\
**Post date:** [May 7, 2021, 11:41am UTC](https://forum.radzen.com/t/time-only-field-from-postgresql/7728/4 "2021-05-07T11:41:29Z")

</div>

You can extend your model with a new string property which converts from and to the desired format. Check this thread for tips: [Calculated fields on the server side](http://forum.radzen.com/t/calculated-fields-on-the-server-side/403)