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
Post a Comment