Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 storing smalldatetime in military time vs. AMPM

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-25 : 13:07:47
Paul writes "I am running SQL SERVER 6.5 on NT.

How can I force SQL SERVER to store, and recall times in military 15:25 vs. standard 3:25 PM.

I checked the Regional Settings Properties and the time was set to HH:mm (24 hour clock), but SQL SERVER still stores and shows the times as hh:mm (12 hour clock)."
   

- Advertisement -