Does anyone know what Column Type the result of the Year() function is? In other words, if I execute:
select Year(Hiredate) as mycolname from mytable; is the result a smallint? a char()? a varchar()? Unfortunately, the manual doesn't say and I can't think of a quick way to figure it out.... Rhino --- rhino1 AT sympatico DOT ca "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies." - C.A.R. Hoare -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]