Paul Schreiber writes:
> Sinisa Milivojevic wrote:
>
> Column start is of type TIME. The actual values are illustrated above in
> the example.
>
> Paul
>
Hi!
Then it is not a bug. As our manual clearly points out, date_format
can be used only on date and datetime column types.
Regards,
Sinisa Milivojevic wrote:
>[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 |
>> +--
[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
>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 |
+--
