Dates and Times

For some Plotalot charts, dates and times must be retrieved as Unix timestamps (the number of seconds since the 1st of January 1970). Dates and times are usually stored in databases as date, datetime or timestamp column types, so you usually need to convert them in your queries. For example:

SELECT UNIX_TIMESTAMP(`purchase_date`), `quantity` FROM `my_table`

The query requirements for each column are listed with the detailed descriptions of each chart type, later in this guide.