mercredi 27 juillet 2016

Date difference in days (excluding weekends/BigQuery)

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