DateTime Culture Swedish Format???

• mustapha-721538

  Right there with Babe

  Points: 774

  More actions

  July 23, 2010 at 3:50 am

  #224467

  Hi,

  How can I use the format the date time to swedish is there any table and examples for this?

  I ´d like to get the date in the following format : 2010 Oktober 09

  regards

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  July 23, 2010 at 4:58 am

  #1197426

  Hi,

  Use the following Query...........Better to write a Function for this....

  SELECT Convert(VARCHAR(30),

  CAST(DATEPART(YYYY,GETDATE()) AS VARCHAR(4))+' '

  + CASE DATEPART(MONTH,GETDATE())

  when 1 Then ' January '

  when 2 Then ' February '

  when 3 Then ' March '

  when 4 Then ' April '

  when 5 Then ' May '

  when 6 Then ' June '

  when 7 Then ' July '

  when 8 Then ' August '

  when 9 Then ' September '

  when 10 Then ' October '

  when 11 Then ' November '

  when 12 Then ' December ' END

  + CAST( DATEPART(dd,GETDATE()) AS VARCHAR(2)))

  Cheers!

  Sasidhar Pulivarthi