Showing month where expression is now()

TheWock · #1 (**permalink**) 12-13-05, 06:09

Hi,

The answer to the question is probably very easy, still I can't find the answer. I've read the manual about date and time functions in MYSQL.

It shows a lot of examples like 'select month('1998-02-01')' which gives '02' as result.

What I want now is to select the month from the current date. In theory, the query should be something like 'select month('curdate()') but unfortunately, that doesn't work.

My question is, what should the query be?

jfulton · #2 (**permalink**) 12-13-05, 08:34

Use DATE_FORMAT:

Code:

SELECT DATE_FORMAT( NOW() , "%c" )

http://dev.mysql.com/doc/refman/5.0/...functions.html

Internet Services

Web Development

Digital Marketing

Consumer Tech