extract only month from timestamp columns

[vanir88]

Hi

i have a columns [create date] , i have to extract only Month as a separate column

 [Create date] data is like below

9/27/2022 10:54:23 PM

any suggestions please

[vinieme12 · Accepted solution]

As below

Month(Timestamp#([Create date],'MM/DD/YYYY hh:mm:ss tt')) as  Month