1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
1
try date_parse or from_iso8601_date function.
select date_parse(substr('2022-11-16T00:00:00.000Z',1,10),'%Y-%m-%d')
--OR TRY BELOW
select from_iso8601_date(substr('2022-11-16T00:00:00.000Z',1,10))
For a full list of functions, please check the reference based on the Athena Engine version you are using https://docs.aws.amazon.com/athena/latest/ug/functions.html Reference: https://trino.io/docs/current/functions/datetime.html?highlight=date_parse#date_parse
beantwortet vor einem Jahr
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
Thanks for your response, it helps!! (I was trying to avoid substring function in the beginning)
The above functions are helpful and I tried this as well and it worked- select date_parse(snapshot_date,'%Y-%m-%dT%H:%i:%s%.000Z') as date --> (This will convert to Date time (zone) format)
select date_parse(substr('2022-11-16T00:00:00.000Z',1,10),'%Y-%m-%d') --> (This will convert to Date time format)
select from_iso8601_date(substr('2022-11-16T00:00:00.000Z',1,10)) --> (This will convert to date format)