Post reply

Date converting in Visual Studio

  • March 26, 2010 at 7:21 am

    #98646

    All right, I'm going to try this another way.

    I am using Visual Studio 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?

  • March 26, 2010 at 7:42 am

    #1140338

    declare @MyDate datetime

    select @MyDate = '2/22/2010 8:20:06 PM'

    select @MyDate, CONVERT(varchar,@MyDate, 101) + ' ' + CONVERT(varchar,@MyDate,114)

    Converting oxygen into carbon dioxide, since 1955.

  • March 26, 2010 at 8:06 am

    #1140363

    Thanks, I really appreciate your help. Works great.

  • March 26, 2010 at 9:39 am

    #1140458

    Thank you for the feedback.

    Converting oxygen into carbon dioxide, since 1955.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply