I want to convert ColeDateTime to CTime

Question

I am reading datetime from a database in format ColeDateTime. I want to convert it to CTimeto get the month date year and time.

CString repDt; //**this will hold the datetime which i read from Database**

COleDateTime dt; 
//**my datetime format is mm/dd/yyyy.**

dt.ParseDateTime(repDt);   **//this line of code gives exception**

CTime t(dt.GetYear(), dt.GetMonth(), dt.GetDay(), dt.GetHour(),
        dt.GetMinute(), dt.GetSecond());
m_time=t.GetTime();

Please give me some solution, how can I do this?

Thanks in advance.

Answer 1

The constructor CTimeaccepts the structures SYSTEMTIMEand DBTIMESTAMP, therefore, both of them will work:

SYSTEMTIME st;
if (dt.GetAsSystemTime(st))
    t = CTime(st);

DBTIMESTAMP dbts;
if (dt.GetAsDBTIMESTAMP(dbts))
    t = CTime(dbts);

Answer 2

Please, try

COleDateTime dt=COleDateTime(2013, 12, 12,12,12,56);
CTime ctime;
SYSTEMTIME systime;
dt.GetAsSystemTime(systime);
ctime = CTime(systime);