1 message in com.mysql.lists.win32Bug on Hour() on Time data type, it r...
FromSent OnAttachments
Jack Chan28 Sep 2000 11:53 
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:53:58 AM
List:com.mysql.lists.win32

Hi

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??

regards Jack Chan