1

What is the best way to convert a timestamp in a string format '2022/09/02 16:55:14.077' to a date format in Athena?

Guru Stron
  • 102,774
  • 10
  • 95
  • 132
nchiero
  • 13
  • 3
  • Have you tried using [cast with date_parse](https://stackoverflow.com/questions/48152596/amazon-athena-convert-string-to-date#:~:text=can%20also%20use-,cast,-function%20to%20get)? – griv Sep 19 '22 at 18:33
  • Does this answer your question? [Amazon Athena Convert String to Date](https://stackoverflow.com/questions/48152596/amazon-athena-convert-string-to-date) – John Rotenstein Sep 19 '22 at 21:49
  • Can you post the error or expected outputs that you want ? – Prabhakar Reddy Sep 20 '22 at 01:03

0 Answers0