Using MYSql 4.0.18 and CRLab data provider 2.7 I have a table with fields defined as DATE, which should only be the date portion. In the administrator and other data table viewing tools the fields only hold the date portion.
When the data is retrieved using the data adapter into a typed dataset the date fields also contain a time portion. All set to 12:00:00.
Is there a way to fix this? the data should only contain the Date portion for a date field.
Thanks
Date field types showing time
We tested our product and found no problems with Date fields.
To avoid your problem try to change typed dataset schema and manually set field type to "date".
If it doesn't work send us small test project to reproduce the problem; it is
desirable to use 'test' schema objects (table `emp` has field `hiredate`) otherwise include definition of your own database objects; don't use third party components.
To avoid your problem try to change typed dataset schema and manually set field type to "date".
If it doesn't work send us small test project to reproduce the problem; it is
desirable to use 'test' schema objects (table `emp` has field `hiredate`) otherwise include definition of your own database objects; don't use third party components.
Re: Date field types showing time
Sounds more like a format issue than the data provider. Look in the MySql documentation for DATE FORMAT functions.bdejong wrote:Using MYSql 4.0.18 and CRLab data provider 2.7 I have a table with fields defined as DATE, which should only be the date portion. In the administrator and other data table viewing tools the fields only hold the date portion.
When the data is retrieved using the data adapter into a typed dataset the date fields also contain a time portion. All set to 12:00:00.
Is there a way to fix this? the data should only contain the Date portion for a date field.
Thanks