Getting month using DATE_FORMAT()

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
apek
Forum Commoner
Posts: 96
Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru

Post by apek »

how if i want to use date_format to month that without leading zero?
in mysql date_format,theres only %m,which month with leading zero...
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

MySQL manual wrote: %m Month, numeric (01..12)
%c Month, numeric (1..12)
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Please don't hijack other threads for separate questions and post in the relevant forum. I've split this from the hijacked thread and moved it to the Database forum.

Mac
Post Reply