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

[BadJerry]

This is what I use: COleDateTime timField; _variant_t varValue; varValue.Clear(); varValue = m_pRecordset->Fields->GetItem(strFieldName)->GetValue(); if ( varValue.vt == VT_DATE ) //lint !e1036 !e569 { timField.m_dt = varValue.date; timField.SetStatus(COleDateTime::valid); } else timField.SetStatus(COleDateTime::null);

[PrafullaVedante]

sorry jerry but it doesent work at my side it still gives me 00:00:00 . Data type of "StartTime" in database is "time"

Prafulla Vedante