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