How to move a DateTime column in sql to Timestamp influxdb

time
#1

i have a datetime column in sql (store some date for events ) and i want to make it the timestamp in influxdb???

1 Like
#2

Not sure what SQL database you’re using, but in all likelihood, your sql query is returning a date object and not a timestamp, so you’ll have to convert the date to a timestamp. There’s a good list of examples of how to convert dates to timestamps here: http://timestamp.online but it will largely depend on what SQL database you’re using and/or what language you’re using to query said database and then post results to InfluxDB.

Best regards,
dg