I have been going round the internet looking for the best way to convert my timestamp values from my dateadded column : 2017-04-05 15:24:15 and obtain month name APRIL as the output.
Which is the best query to do this.
Asked
Active
Viewed 40 times
1
-
1which dbms are you using? – SqlZim Apr 05 '17 at 12:43
-
I am using XAMPP @sqlzim – Beroo Apr 05 '17 at 12:45
-
1xampp isnt a database. I assume you mean mysql? – Takarii Apr 05 '17 at 12:47
-
Possible duplicate of [MySQL MONTHNAME() from numbers](http://stackoverflow.com/questions/7027129/mysql-monthname-from-numbers) – Takarii Apr 05 '17 at 12:49
-
If an Answer solves your problem, and you are satisfied that no other answer that might appear might prove more suitable, then you should accept the answer (choose the tick). – toonice Apr 05 '17 at 12:59
1 Answers
1
In MySql, use monthname()
select
dateadded
, monthname(dateadded) as MonthName
from t
SqlZim
- 37,248
- 6
- 41
- 59