mardi 21 avril 2015

how to convert date in English and French

I am trying to update date in my tables, so I have date as 20150621 and I want it as June 21, 2015 and 21 juin 2015 (for French).

I have a query: convert(varchar(12),cast([datecolumn]) as datetime),107)

So its changing to: Jun 21,2015 , but I need June 21,2015 and also French date.

I am using Sql 2005, so format doesn`t work in it.

Aucun commentaire:

Enregistrer un commentaire