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

What are the types of index?

0 Answers  

What is acid in mysql?

0 Answers  

Which is better mysql or microsoft sql?

0 Answers  

How do I install mysql on windows 7?

0 Answers  

What is root password?

0 Answers  




What is table level locking in mysql?

0 Answers  

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  

What are procedures in mysql?

0 Answers  

What is pragma exception?

0 Answers  

What is datatype in mysql?

0 Answers  

Why we use mysql database?

0 Answers  

How to use rank function in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories