google bigquery - Add five hours to timestamp field -


i want add few hours eg: 5hours 30 mins timestamp field using bigquery. timestamp field in format - '2016-05-03 21:35:03'

how can in bigquery?

select    ts,    date_add(ts, 330, "minute") ts_plus_530     (select current_timestamp() ts),   (select timestamp("2016-05-03 21:35:03") ts) 

see date_add more details


Comments