I am trying to fetch the details of

[vasanthgnb]

I am trying to fetch the details of a date field from MS access database using SQLDecribeCol command. but the function returns me that the specified field is of timestamp data type and its size as 23 bytes. when the database is referred, the datatype is date and the size is 8 bytes. i want the SQLDescribeCol to fetch the correct data type (date) and size (8 bytes). please help me out as soon as possible.

 

[dcm]

vasanthgnb: I would suggest that Access is returning the correct data type as it is common for Access to maintain datetime fields even if you only format them as a date. David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner