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 |
>> +----------+----------+
>> | 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.
Column start is of type TIME. The actual values are illustrated above in
the example.
Paul
shad 96c / 4B CS / mac activist / eda / fumbler
fan of / jewel / sophie b. / sarah slean / steve poltz / emm gryner /
/ x-files / buffy / dawson's creek / habs / bills / 49ers /
t h i n k d i f f e r e n t.
"Mulder, not everything is a labyrinth of dark conspiracy, and not
everybody is plotting to deceive, inveigle, and obfuscate.
...
Where are you going?"
-- Dana Scully, "The X-Files"
"To find someone who I know plotted to deceive, inveigle, and obfuscate."
-- Fox Mulder, "The X-Files"
---------------------------------------------------------------------
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
