SQL Timestamp Format

Ignition
1

Is there a way to take a SQL tag history query that would then, when exported to .csv could break out the timestamp column into two columns? One for date and one for time?

2

Show us how you're retrieving the data.

  • If you're using a tag history binding then you'll need a script transform.
  • If you're writing your own SQL query you can use SQL's CONVERT function.