need help on convert function dates

• kbhanu15

  SSCarpal Tunnel

  Points: 4498

  More actions

  March 12, 2014 at 1:35 pm

  #290906

  hi all,

  please help me to get this out put.

  details:

  declare @deadline Datetime = '2014-03-23 15:30:10.000'

  SELECT CONVERT(VARCHAR(30),@deadline, 100) AS DateConvert

  ----With this I am able to produce that like

  ----o/p: Mar 23 2014 3:30PM

  declare @deadline1 Datetime = '2014-03-03 15:30:10.000'

  SELECT CONVERT(VARCHAR(24),@deadline1, 100) AS DateConvert

  --o/p: Mar 3 2014 3:30PM

  --expected O/p: Mar 03 2014 03:30PM

  Please suggest the correct date format to achieve this.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  March 12, 2014 at 1:40 pm

  #1696541

  A replace can work for you.

  SELECT REPLACE( CONVERT(VARCHAR(24),@deadline, 100), ' ', ' 0')

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• kbhanu15

  SSCarpal Tunnel

  Points: 4498

  More actions

  March 12, 2014 at 1:47 pm

  #1696542

  thank you so much for your help.