sqlgoogle-bigquery
How to get TIMESTAMP of 15 minutes ago using BigQuery?
Found this but this doesn't run on standard SQL
I tried to do:
WHERE datew > DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 5 DAY )
But this doesn't work. According to the docs DATE_SUB supports only
DAY
WEEK. Equivalent to 7 DAYs.
MONTH
QUARTER
YEAR
How can I get current time stamp - 15 minutes on standard SQL with BigQuery?
Solution
Check out timestamp_sub() function.
How to use it:
SELECT
CURRENT_TIMESTAMP() AS now,
TIMESTAMP_SUB(CURRENT_TIMESTAMP(),INTERVAL 15 MINUTE) AS ago_15_min
Results
- Filter rows using Row number and partition by columns and a business logic
- How to check the existence of related records in group by query?
- I can't call the data properly into my html page
- SQL triggers column updating sequence
- Return entries within last 24 hours of a specific date time in SQL
- Codeigniter using LIKE with WHERE in SQL query
- Case causing ORA-01790: expression must have same datatype as corresponding expression error
- Create multiple OR LIKE conditions on the same column using CodeIgniter query building methods
- Script to save varbinary data to disk
- Excel VBA create 2 temp tables and enter the output into a third temp table and output to excel sheet
- Generate report converting rows into column using multiple tables
- How to debug SSIS package in SQL Server Management Studio 2017?
- Update multiple column of a SQL table based on another table
- How to sum 2 values from different queries?
- "ERROR: invalid input syntax for type numeric: NULL" postgresql
- "The big SQL RegEx": How do I RegEx split an easy SQL query (SELECT ... INTO ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY)?
- VBA To Parse Userform Name In Method
- Match a list of patterns using SQL IN and LIKE
- DuckDB: how do I use the result of a query on `DESCRIBE` to `SELECT` from a table?
- Delete all similar rows except first one
- Installing MySQL on the D: drive instead of C:
- Adding an index to query result
- Update records in a SharePoint List by SQL via VBA/ADO?
- Return rows where column value is final superset of preceding rows
- Is there any intuitive reason why SQL syntax is handled in this order?
- Assign Updated Time when a specific column change in SQL
- Converting bytes to kilobytes/megabytes
- Insert multiple rows at once with CodeIgniter's active record method
- JOIN query causes column name collisions in SELECT * clause
- Conditionally add an OR WHERE IN () condition using CodeIgniter's query building methods