Page 1 of 1
Date field types showing time
Posted: Fri 28 Jan 2005 00:16
by bdejong
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
Posted: Mon 31 Jan 2005 10:39
by Serious
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.
Re: Date field types showing time
Posted: Wed 09 Feb 2005 05:14
by avi8tor
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
Sounds more like a format issue than the data provider. Look in the MySql documentation for DATE FORMAT functions.