Hardcode date in SELECT clause (Athena)

Question

Would anyone have any advice on how to hardcode a specific date into my SELECT clause?

I'm trying to force a date into my query so I can reference it later, but unsure how to go about this.

Thanks in advance! Sam

TL;DR Having issues writing a specific date into the SELECT in Athena/SQL

Check if [this](https://stackoverflow.com/questions/6345635/how-to-select-several-hardcoded-sql-rows) solves your doubts — Zero, Jul 05 '23 at 11:22
Use whatever format you want and parse it ref: https://stackoverflow.com/q/69716449/125981 — Mark Schultheiss, Jul 05 '23 at 22:12

ChoNuff · Answer 1 · 2023-07-08T01:50:32.580

Here are a few ways to hardcode a timestamp to a column:

select 
     timestamp '2023-07-07 12:34:56' as ts,
     date '2023-07-07' as dt,
     from_unixtime(1688733296) as unix_time

If you're using Athena engine v3.0 (Trino), you can use this reference: https://trino.io/docs/current/functions/datetime.html

score 0 · Accepted Answer · edited Jul 12 '23 at 22:55

0

Thanks for your help all - I've managed to do what I needed to do by using this:

(CAST("date_trunc"('month', "date_add"('month', -1, current_date)) AS date)

This has locked the date I need to use until the next month rolls around and it'll then update accordingly.

Thanks for all your help!

edited Jul 12 '23 at 22:55

XMehdi01

answered Jul 11 '23 at 08:25

sawillson11

2 Answers2