1回答
- 新しい順
- 投票が多い順
- コメントが多い順
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
回答済み 1年前
関連するコンテンツ
- 質問済み 6ヶ月前
- AWS公式更新しました 2年前
- AWS公式更新しました 3年前
- AWS公式更新しました 1年前
- AWS公式更新しました 3年前
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)