1 Answer
- Newest
- Most votes
- Most comments
0
I think based on the tags you're using Athena, so date_diff may be the answer. The official AWS documentation links to Presto.
Other database systems also support DATEDIFF: MySQL, MS SQL Server and Oracle. With POSTGRES you could use DATE_PART, see http://www.sqlines.com/postgresql/how-to/datediff.
answered 2 years ago
Relevant content
- asked 5 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago