DATETIME PARSE to YYYY-MM-DD

[kathbanc]

Hi Alteryx Community! 

Input :  8/8/2022 10:17:00 AM

Output should be : YYYY-MM-DD

Thank you in advance

[Personne]

Hi,

If you are in "IN-BD" mode with Oracle :

to_char("YOUR_COLUMN_DATE", 'yyyy-mm-dd')  

[Qiu · Accepted solution]

@kathbanc 

We can use the DateTImeParse function in the Formula tool

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html##

[kathbanc]

Thank you so much @Qiu