How to format datetime column to 24 hours format

[Gita Gayatri Sahoo]

I want to format a column (in datetime) to 24 hours datetime format. In analysis, I opened formatting for that column and wrote a custom format string like: MM/dd/yyyy HH:mm:ss. But the value is always showing in default format i.e. in 12 hours.

I'm using presto database and there the column values are in 24 hours format. Anyone please help me in this.

Thanks

[Kirsten Smith (she/her)]

DateTime columns look at the Regional settings on your computer, so try changing that to 24-hour time and you should see the expected data in Spotfire.

[Donald Johnson]

A comment from pchetty87,

 

Misleading as this can be changed in Spotfire without the need for changing regional settings. Refer to the below: https://docs.tibco.com/pub/spotfire_server/7.10.0/doc/html/en-US/TIB_sfire-bauthor-consumer_usersguide/GUID-D997D316-2686-413F-9417-4A52F37754CA.html

[Danielle Topalsky]

Capital H and HH reference the 24 hour clock whereas using lower case h is for 12 hour. Looks like you've already been using capital H but Spotfire may not be recognizing the format so you can try the following: 

 

ParseDateTime([Column Name],"MM/dd/yyyy HH:mm:ss")