sql - Using date_add () with date_trunc () in presto - Stack Overflow
Feb 5, 2022 · Using date_add () with date_trunc () in presto Asked 3 years, 9 months ago Modified 3 years, 9 months ago Viewed 7k times
presto - SQL Unnest - how to use correctly? - Stack Overflow
Mar 4, 2022 · SQL Unnest - how to use correctly? Asked 3 years, 9 months ago Modified 1 year, 8 months ago Viewed 27k times
Presto SQL - Converting a date string to date format
I'm on presto and have a date formatted as varchar that looks like - 7/14/2015 8:22:39 AM I've looked the presto docs and tried various things (cast, date_format, using split_part to parse and the...
sql - Presto check if NULL and return default (NVL analog ... - Stack ...
Apr 7, 2017 · Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return a default value. I solve this somehow like this: SELECT CASE WHEN my_field is null THEN 0 ELSE
Presto SQL WHERE filter for a column that contains an array of structs
Nov 4, 2020 · Presto SQL WHERE filter for a column that contains an array of structs Asked 5 years, 1 month ago Modified 3 years, 9 months ago Viewed 13k times
sql - presto split single column value to multiple rows - Stack Overflow
Oct 9, 2020 · I have a table on presto that has records of multiple records. From that record, I used this simple SQL query, select id, data from my_table where id IN (1,7) This is what I get from that query, i...
Presto sql: presto extract substring for the last occurrence of ...
Oct 13, 2022 · Presto sql: presto extract substring for the last occurrence of character in string Asked 3 years, 1 month ago Modified 10 months ago Viewed 2k times
How to exclude items from search using NOT LIKE and % in Presto SQL?
Apr 12, 2020 · NOT LIKE is certainly supported in Presto. If item_name is varbinary, you need to convert this first to varchar, perhaps using from_utf8() function.
presto - How to extract only the hour from a timestamp in sql? - Stack ...
Mar 9, 2022 · How to extract only the hour from a timestamp in sql? Asked 3 years, 8 months ago Modified 3 years, 8 months ago Viewed 16k times
Presto SQL : Changing time zones using time zone string coming as a ...
Sep 8, 2018 · Presto 320 adds with_timezone (for timestamp values) at_timezone (for timestamp with time zone values) exactly for this purpose. If you are using older Presto version (such as Athena as …