Member Avatar for extemer

hello guys i want to get the month in single numeric value e.g 5 i sort this way but it print me 05 e.g date('m') ..help me

  • 2 Contributors
  • 1 Reply
  • 75 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by d5e5
Member Avatar for d5e5 
mysql> select curdate();
+------------+
| curdate()  |
+------------+
| 2011-05-01 |
+------------+
1 row in set (0.00 sec)

mysql> select MONTH(CURDATE());
+------------------+
| MONTH(CURDATE()) |
+------------------+
|                5 |
+------------------+
1 row in set (0.00 sec)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.