How to convert String to Date in Amazon Athena?

0 votes
I am trying to convert the following string: mmm-dd-yyyy to a date: yyyy-mm-dd

e.g: Jan-01-2019 to 2019-01-01

within Amazon Athena. Is it possible? How can I do that?
Jan 16 in AWS by Anjali
• 2,910 points
414 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
You can use date_parse. All you need to do is adjust your regex accordingly.

select date_parse('Jan-01-2019','%b-%d-%Y')

2019-01-01 00:00:00.000
answered Jan 16 by chandan

Related Questions In AWS

0 votes
1 answer

How to upload a lib for Tomcat in Amazon EC2?

You need to set the proper privileges ...READ MORE

answered Aug 20, 2018 in AWS by Archana
• 3,770 points
26 views
0 votes
1 answer

How to list the contents of Amazon S3 by modified date?

One easy solution would be probably to ...READ MORE

answered Aug 21, 2018 in AWS by datageek
• 2,390 points
1,788 views
0 votes
1 answer

How to connect Amazon RedShift in Apache Spark?

It turns out you just need a ...READ MORE

answered Aug 22, 2018 in AWS by Archana
• 3,770 points
773 views
+1 vote
1 answer
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

How to store Amazon Athena Query Results into new Table?

This is not supported by Athena as Amazon ...READ MORE

answered Jan 16 in AWS by heena
114 views
0 votes
1 answer

Is there a Command line tool to access Amazon Athena?

The AWS command line tool supports Amazon Athena operations. 1. ...READ MORE

answered Jan 16 in AWS by rishab
100 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.