|
|
Posted by lorento on 10/10/81 11:51
I think you should not use time as column type..
better use VARCHAR(5)
--
http://www.deshot.com
Ridge Burner wrote:
> Sorry, I know this NG focuses on PHP, and not MySQL, but I cannot find any
> English MySQL NG through my ISP, and since most PHP users out there use some
> type of database system.......well it's worth a shot!
>
> I created a table with a column type of 'time'. The default format for this
> column is => 00:00:00 (HH:MM:SS). The form I made to populate the table has
> the time in this format => 00:00 (MM:SS), without the hours explicitly
> specified. So when I intended to store something like 3:49 (3 minutes
> forty-nine seconds), it actually stores it as 03:49:00 (3 hours forty-nine
> minutes)!
>
> I am hoping someone can help me out with whatever SQL I need to convert the
> times to the correct format.
> Basically, I need to convert '02:35:00' to '00:02:35' in a time column.
>
> Thanks for any help you can give me!
>
> --Ridge
Navigation:
[Reply to this message]
|