Bug on Hour() on Time data type, it return minute value on Datatype "Time" - Jack Chan - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugsBug on Hour() on Time data type, it r...

From	Sent On	Attachments
Thimble Smith	27 Sep 2000 17:54
Jack Chan	28 Sep 2000 11:57

Subject:	Bug on Hour() on Time data type, it return minute value on Datatype "Time"
From:	Jack Chan (jack...@hotmail.com)
Date:	09/28/2000 11:57:20 AM
List:	com.mysql.lists.bugs

I have install mysql version mysql-3.23.22-beta for windows. My platform is
windows 2000 professional.I use myodbc-2.50.31-For windows NT.

I have a test table that have 3 fields Date1, time1, and datetime.

Date1(Date type= Date) Time1(DT=Time)
Datetime(DT= Datetime) 25/09/2000 12:58:45
25/09/2000 11:12:10

When i use the following command

"Select hour(Time1) as hour from test"

It return

Hour 58 (which is the Miniute, it should be Hour)

Can you tell me how to solve it??