[EMAIL PROTECTED] writes:
> >Description:
> date_format is setting times to 12:00 AM; time_format works fine
> >How-To-Repeat:
> mysql> select start,TIME_FORMAT(start, '%l:%i %p') AS start2 FROM time;
> +----------+----------+
> | start | start2 |
> +----------+----------+
> | 12:00:00 | 12:00 PM |
> | 14:00:00 | 2:00 PM |
> +----------+----------+
> 2 rows in set (0.01 sec)
>
> mysql> select start,DATE_FORMAT(start, '%l:%i %p') AS start2 FROM time;
> +----------+----------+
> | start | start2 |
> +----------+----------+
> | 12:00:00 | 12:00 AM |
> | 14:00:00 | 12:00 AM |
> +----------+----------+
> 2 rows in set (0.06 sec)
<cut>
Hi!
And column start is of what type and what are it's actual values.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
