https://www.growthbook.io/ logo
w

wide-jordan-14758

02/28/2023, 6:10 PM
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

fresh-football-47124

02/28/2023, 7:36 PM
@future-teacher-7046 ^
f

future-teacher-7046

02/28/2023, 7:39 PM
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

wide-jordan-14758

02/28/2023, 10:09 PM
Got it, thanks!
8 Views