How to insert a "datetime" data apart form the insert timestamp

#1

How to insert data ( key field value) like a full datetimestamp or epoch secs “not string” like exchange trade-open time say from fincal which has no bearing on the insert timestamp.

I tried “source-time”=1451606441.013004[“s”] does not work… etc

#2

There isn’t a time data type so usually I insert them as a int in nanoseconds: source_time_ns=1451606441013004000i

1 Like