Show AM/PM in DateTime

See more:

AQL

Hi,

Note: AQL is not listed in the tags, so using SQL as a category. Apologies for that.

I am running ariel query in QRadar to get datetime format. But it's showing only date/time and not AM/PM.

Query: select DATEFORMAT(1446125637000,'dd-MM-yyyy hh:mm:ss') from events limit 1
This query is to convert bigint to datetime format.

Please help.
Thanks in advance