How to convert date field "Dec 1 2018 6:38PM" to dd-mm-yyyy (01-12-2018)` in Dremio?
Asked
Active
Viewed 2,741 times
-1
Joakim Danielson
- 43,251
- 5
- 22
- 52
user11043921
- 11
- 1
- 1
-
Welcome to SO. You may want to check out https://stackoverflow.com/conduct – Ponni Feb 11 '19 at 07:33
-
@Ponni that's a little strange choice, maybe you meant [how to ask](https://stackoverflow.com/help/how-to-ask)? – Joakim Danielson Feb 11 '19 at 07:44
-
You have tagged your question with sql so what DBMS are you using? Please tag your question with the correct database so that we can help you. – Joakim Danielson Feb 11 '19 at 07:45
1 Answers
0
select to_timestamp('Dec 1 2018 6:38PM','mon dd yyyy hh:miAM')
Date/Time formats here: https://docs.dremio.com/sql-reference/sql-functions/datetime-formats.html
Joe
- 6,767
- 1
- 16
- 29