SQL - Convert date into string

Question

I have a table with a date column in it ('yyyy-mm-dd'). I want to be take from that column the month of each date and print it out as in 'MMM' style or the full name of the month (E.g 2017-09-22 --> "Sept" or "September")

I know how to extract the month but not how to convert it...i tried something with NAMEDATE that i found in a similar question but i was getting errors... any tips?

Date conversion functions vary from vendor to vendor. Are you asking for SQL Server or MySQL? — Strikegently, Sep 22 '17 at 11:29
Possible duplicate of [Convert Month Number to Month Name Function in SQL](https://stackoverflow.com/questions/185520/convert-month-number-to-month-name-function-in-sql) — Kh.Taheri, Sep 22 '17 at 11:29
I removed the incompatible database tags. Please tag with the database you are really using. In MySQL, you want the `date_format()` function (in SQL Server, either `format()` or `convert()`). — Gordon Linoff, Sep 22 '17 at 11:29
@Kh.Taheri I have tried that as you can see from what I wrote. It didn't work — noel293, Sep 22 '17 at 11:30
Please take the time to work out which database you're using, also take the time to write down what you tried and what error you got. These are the first steps to solving it yourself. — Nick.Mc, Sep 22 '17 at 11:32
@Nick.McDermaid I asked for tips not for you to solve it for me! O.o — noel293, Sep 22 '17 at 11:33
That was a tip... a tip that might lead to you solving it yourself — Nick.Mc, Sep 22 '17 at 11:35
You need to write your using MySQL and not SQL. This will give you the correct answers. — SqlKindaGuy, Sep 22 '17 at 11:39
No - @GordonLinoff asked you, and you said SQL. And that is not the same. — SqlKindaGuy, Sep 22 '17 at 11:41
@plaidDK i said " sql...im using it on workbench" MYSQL Workbench (the program you know?) — noel293, Sep 22 '17 at 11:42

score 2 · Accepted Answer · answered Sep 22 '17 at 11:33

2

Use MONTHNAME

SELECT MONTHNAME('2008-02-03');
        -> 'February'

answered Sep 22 '17 at 11:33

Stranger

134
6

@GeorgeXReplay if it full fill your requirement then accept it by clicking on right mark under vote count – Imran Ali Khan Sep 22 '17 at 11:40

SQL - Convert date into string

1 Answers1