Convert timestamp in SQL Query to 24-hour rather than 12-hour format

I have a calculation that takes this information from another field: 5/11/2006 10:27 AM
and converts it to: {ts '2006-5-11 10:27:0'}

Here's the calculation:

"{ts '" & Year (fDate_Modified_GREATEST) & "-" &
Month (fDate_Modified_GREATEST) & "-" &
Day ( (fDate_Modified_GREATEST)) & " " &
Hour (fDate_Modified_GREATEST) & ":" &
Minute (fDate_Modified_GREATEST) & ":" &
Seconds (fDate_Modified_GREATEST) & "'}"

In the above example, it returned records with the following timestamps (data represented exactly how it is on SQL server, format and all)...

5/11/06 9:58 AM
5/11/06 1:35 PM
5/11/06 10:36 AM
5/11/06 12:55 PM
5/11/06 8:43 AM
5/11/06 9:37 AM
5/11/06 12:50 PM
5/11/06 10:39 AM
5/11/06 8:30 AM
5/11/06 2:01 PM
5/11/06 10:27 AM

What's going on here?

Solution: Convert timestamp in SQL Query to 24-hour rather than 12-hour format

don't you have any setting to change that in the odbc parameters?
otherwise, all you've got to do is add to all records finishing with 'PM' an extra 12 hours