Convert Standard time to Military time in SSRS

• considineb

  SSC Veteran

  Points: 210

  More actions

  March 23, 2010 at 6:56 am

  #96641

  I am new to SSRS (SQL Server Reporting Services) and am having trouble converting time/day from;

  ie. Standard Time = "2/22/2010 8:20:06 PM"

  to Military Time = "2/22/2010 20:20:06 "

  I have been trying to perform this conversion using an Expression for the date field I am converting, but with no luck.

  Can anyone help?

• schleep

  SSChampion

  Points: 12587

  More actions

  March 26, 2010 at 1:26 pm

  #1140703

  SELECT CONVERT(VARCHAR, GetDate(), 101) + ' ' + CONVERT(VARCHAR, GetDate(), 114)

  See CONVERT in BOL.