IsTime doesn't work with TIMESTAMP type?

  • Resolved melchoir55

    (@melchoir55)


    11 years, 8 months ago

    I just installed the pro version and tried putting some graphs together. One of the things we need is a graph which shows changes over time. Our database automatically saves time on record entries using the MySql timestamp functionality. Since this is a standardized format which all mysql databases will share, I expected it to be trivially easy to integrate into a graph. However, when I pass a timestamp into a chart, I get really weird results. It is obviously not parsing the timestamp correctly.

    Is there a way to format how it parses the timestamp?

    https://wordpress.org/plugins/wp-business-intelligence-lite/

Viewing 1 replies (of 1 total)
  • claudio

    (@calberti)

    11 years, 8 months ago

    The latest version of the plugin (1.5) to be released in sept 2014 is supporting MySQL timestamps via UNIX_TIMESTAMP to be used in the query.

    e.g.

    select UNIX_TIMESTAMP(date) as date, price from stocks order by date ASC

Viewing 1 replies (of 1 total)

The topic ‘IsTime doesn't work with TIMESTAMP type?’ is closed to new replies.