I would like to get the exact amount of days between two timestamps (ex. 1.45 days). The thing is BigQuery datediff function rounds the day and only accepts 2 timestamp arguments.
SELECT
datediff(start_time_pac_tz, end_time_pac_tz) as Date_difference
Date_difference
-6
Also I'm looking to exclude weekends. Any help is greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire