Show int as datetime

  • Resolved HKCCCC IT

    (@hkcccc)


    10 months, 2 weeks ago

    I have a column ‘created’ int(10) unsigned that would like to show as date time. In SQL I can use formula from_unixtime(created). How to do so in app builder?

Viewing 1 replies (of 1 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    10 months, 2 weeks ago

    Hi @hkcccc,

    Thanks for the post!

    You can use a Computed Field to show the field as formatted time in the App Builder.

    You will have to use a JavaScript function to do the conversion/formatting.

    If you have any further questions, please send us a message via Contact | WP Data Access, as this is a premium feature. 🙏

Viewing 1 replies (of 1 total)

The topic ‘Show int as datetime’ is closed to new replies.