Hi! Is there a limit on the precision of the `time...
# announcements
w
Hi! Is there a limit on the precision of the
timestamp
column in either the experiment assignment query or metric queries? Can the seconds place be several decimal places long?
cc @ambitious-apartment-58735
f
@future-teacher-7046 ^
f
I don't think there's a restriction on our side. Timestamps are just used internally in the query for filtering, but aren't passed back to us in the final result. So as long as the db engine supports higher precision I think that should work. The one exception might be BigQuery, since we cast all timestamps to the DateTime type before using them.
w
Got it, thanks!