Date field types showing time

Date field types showing time

Postby bdejong » Fri 28 Jan 2005 00:16

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
bdejong
 

Postby Serious » Mon 31 Jan 2005 10:39

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.
Serious
 

Re: Date field types showing time

Postby avi8tor » Wed 09 Feb 2005 05:14

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.
avi8tor
 
Posts: 18
Joined: Sat 06 Nov 2004 12:45
Location: Gig Harbor, Washington USA


Return to dotConnect for MySQL