Okay
  Public Ticket #2703932
DateTime rendering
Closed

Comments

  • Mark Price started the conversation

    Hi,

    I have wordpress datetime set to display H:i:s and I am using mySql DateTime field type in tables/charts which are Y-m-d H:i:s:(fractional seconds)

    I need to resolve time down to nearest 1 second, or preferably 0.1 second, however tables and charts only allow display to nearest minute.

    How do I change this  so that I can report data to 0.1 second ?

  • [deleted] replied

    Hi Mark

    Thank you for reaching out to us.

    Unfortunately this cannot be done by modifying date time settings. You can try using the string type column to add values like that.

    Do let us know if you need any further assistance.

  • Mark Price replied

    I am using standard mysql function date_format and syntax to generate  %Y-%m-%d %H:%i:%s.%f date/time string.

    however your plugin always removes the seconds and fractions element.

    Please provide a fix, or advise a workaround.

  • [deleted] replied

    Hi Mark

    wpDT currently has only two time formats - 12-hour and 24-hour format; no seconds. 

    It would have to be added by code so if you would like to see this implemented in one of our future releases please take the time to leave your suggestion following this link so it would go directly to our developers. 

    The only workaround for now is using the string type column to add values like that as I suggested before.

    Do let us know if there is anything else we can assist you with.