athena query question

You can convert bigint to date timestamp as below:

           date_format(from_unixtime(bigint_timestamp_column/1000),’%Y-%m-%d %h:%i%p')

You can test this by running this sample:

           select date_format(from_unixtime(1688183062393/1000), '%Y-%m-%d %h:%i:%s')

Here is how you'd query your table with condition:

          select * from table_name where date_format(from_unixtime(1688183062393/1000), '%Y-%m-%d %h:%i:%s') > date_parse('2023-07-01', '%Y-%m-%d') and date_format(from_unixtime(1688183062393/1000), '%Y-%m-%d %h:%i:%s') < date_parse('2023-07-10', '%Y-%m-%d')

Hope you find this helpful.

Comment here if you have additional questions, happy to help.

Abhishek

Select DATE_FORMAT(timestamp,'%Y-%m-%d') where timestamp >= timestamp '2023-08-30' and timestamp <= timestamp '2023-09-01'