Time diff in Amazon Athena / Presto (seconds and minutes )

presto amazon-athena
Latent picture Latent · Mar 20, 2017 · Viewed 18.2k times · Source

I have a list of creation time stamps and ending time stamps , i would like to get the amount of seconds last from creation to ending . could not find any way to do that without using UNIX time stamp (which i dont have at the moment) .

something like that :

datediff('second',min(creation_time),max(ending_time))

creation_time = '2017-03-20 10:55:00' ..

Answer

David דודו Markovitz picture David דודו Markovitz · Mar 20, 2017

date_diff

date_diff('second', min(creation_time),max(ending_time))

Related questions

Presto check if NULL and return default (NVL analog)

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 my_field …

Read More
Athena greater than condition in date column

I have the following query that I am trying to run on Athena. SELECT observation_date, COUNT(*) AS count FROM db.table_name WHERE observation_date > '2017-12-31' GROUP BY observation_date However it is producing this …

Read More
Athena date format unable to convert string to date formate

tried the below syntax none of them helped to convert a string type column to date select INVC_,APIDT,APDDT from APAPP100 limit 10 select current_date, APIDT,APDDT from APAPP100 limit 10 select date_format( b.APIDT, '%Y-%m-%d') …

Read More