In my table date format is 2011-06-23, but i want to show the month name in string type, like Jan, Feb e.t.c.
Asked
Active
Viewed 129 times
0
-
http://stackoverflow.com/questions/18467669/convert-number-to-month-name-in-php – Umair Ayub Jun 05 '15 at 04:54
-
Which database are you using? You have selected two different technologies. Do you have really stored data in database with some format (column type is string) or in typed column? – Jan Zahradník Jun 05 '15 at 04:55
-
@Umair *Month Name query in SQL* – Sougata Bose Jun 05 '15 at 04:55
-
yes date format is 2011-06-23, but want to show in string type, i.e, 06 should be fetched as june, – Anil bhadula Jun 05 '15 at 04:58
-
You should really decide if you are working with MySQL or SQL Server. They are totally different products – James Z Jun 05 '15 at 06:26
-
@Anilbhadula SELECT DATENAME(MONTH, Date_Field) – Chiragkumar Thakar Jun 05 '15 at 06:34