Google Bigquery Subtract hours from date
To Subtract an hour from a DATETIME column:
\n\nSELECT \n DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 1 HOUR)\n
\n\nFor TIMESTAMP Columns:
\n\nSELECT \n TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR) \n
dan-irving
posted onEnjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment