Hi,
I built a simple MySql 4.1 structure of data:
CREATE TABLE `test`.`tabtest` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`time` DATETIME NOT NULL,
PRIMARY KEY(`Id`)
)
ENGINE = InnoDB;
... and populated:
INSERT INTO test.tabtest VALUES ( 1, {dt "2005-10-10 10:10:10"} )
INSERT INTO test.tabtest VALUES ( 2, {dt "2005-10-11 10:10:10"} )
... why does the column fdate in select above return string value on MyDac?
SELECT Cast(time as DATE) as fdate FROM test.tabtest GROUP BY time
... the strange is that fdate returns OK(date) in selects above:
SELECT Cast(time as DATE) as fdate FROM test.tabtest GROUP BY id
SELECT Cast(time as DATE) as fdate FROM test.tabtest
... In MySql 5, all selects work ok!
Thank's,
Tato.