problem in retrieving "Time" from database using _RecordsetPtr

[PrafullaVedante]

Here i am developing a application which require to fetch Time from database . But i am getting 00:00:00 AM as a time everytime. We are using MySql database. Code fragment is.... ======================================================== _variant_t vtValue; vtValue = RsSession->Fields->GetItem("StartTime")->GetValue(); COleDateTime d( vtValue ); sprintf( name, "%02d:%02d:%02d",d.GetHour(),d.GetMinute(),d.GetSecond() ); ======================================================== in "name" i am getting "00:00:00" ..everytime.. All the other values i am retrieving from ResultSetPtr are OK. Can any one tell me what is to be done ther .... Thanks in advance

Prafulla Vedante e-mail : prafulla_v@asianitg.com

[Rob Graham]

What is the data type of the field "StartTime"?

[PrafullaVedante]

Data type of the field "StartTime" is "time"

Prafulla Vedante