We are using Drupal to build a site which displays trend chart data and generates reports. We are using the drupal database, adding additional tables, to store our data. When we use Views to use the data, datetime comes up blank. Been spending days trying to find work around and know that we can change the field in mysql to unix timestamp and convert back and forth, etc.. But we would really like to just be able to pull datetime directly in.
Also this data is going to be used for a line graph (using google api). Maybe this is a seperate issue but we want to use datetime as our x-axis and data reading as y but cannot choose what data to use for y. Everything overlaps on x.