1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

How to get full name of monthname ?

Question Posted / raj

Answers were Sorted based on User's Feedback



How to get full name of monthname ?..

Answer / shikha grover

Select date_format(curdate(),'%M') ;

Is This Answer Correct ?    11 Yes 1 No

How to get full name of monthname ?..

Answer / vijay

select monthname(curdate()) as Month_Name;

Is This Answer Correct ?    10 Yes 2 No

How to get full name of monthname ?..

Answer / subhojit

select to_char(sysdate,'Month') from dual

Is This Answer Correct ?    3 Yes 4 No

How to get full name of monthname ?..

Answer / sudhanshu_kmr

select month(now());

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More MySQL Interview Questions

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

0 Answers  

What is mysqli_select_db?

0 Answers  

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

0 Answers  

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  

What is a tinyint in mysql?

0 Answers  




How large can a mysql database become?

0 Answers  

How do you rename a procedure in mysql?

0 Answers  

What mysql means?

0 Answers  

Does mysql use sql?

0 Answers  

What is the innodb in mysql?

0 Answers  

What are procedures in mysql?

0 Answers  

What is difference between pdo and mysqli?

0 Answers  

For more MySQL Interview Questions Click Here
Categories