Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
apek
Forum Commoner
Posts: 96 Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru
Post
by apek » Tue Feb 03, 2004 9:56 am
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...
Weirdan
Moderator
Posts: 5978 Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine
Post
by Weirdan » Tue Feb 03, 2004 11:31 am
MySQL manual wrote:
%m Month, numeric (01..12)
%c Month, numeric (1..12)
twigletmac
Her Royal Site Adminness
Posts: 5371 Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK
Post
by twigletmac » Wed Feb 04, 2004 5:01 am
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