Date and Time Displaying Incorrectly
-
My query is returning a graph but its setting all the dates to 12/31/1969
Query:
SELECT PlantID, CurrTemp, UNIX_TIMESTAMP(StatusTime)
FROM UsersPlants NATURAL JOIN PlantsStatus
WHERE UserID = {{{user_ID}}}
ORDER BY StatusTime AscChart Settings:
Click here for chart settingsResult:
Click here for photohttps://www.ads-software.com/plugins/wp-business-intelligence-lite/
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
- The topic ‘Date and Time Displaying Incorrectly’ is closed to new replies.
