Date AM PM

[ALEX1977ALEX]

Hello

i have this format date

10/19/2019 6:23:26 AM

How can i check if date is AM or PM

i tried with right(my_date,2) but it s a format date so it was wrong

how can i modify in order to have a text format in order to  have a text format?

[ALEX1977ALEX]

hour(date(my_date)) as my_hour,=> automatic transform in the good AM or PM