Month Year in mysql

Nov 28 2009 11:31 PM

hi...in sql from following query: select Convert(datename(mm,getdate()),varchar)+'-'+convert?(year(getdate()),varchar) MONTHYEAR.. vl get, November 2009 but in Mysql ??? pls help me....

Answers (3)

Recursive sql with cursors or left joined sql tables

What is the difference between the data types char and varchar?