want to convert ColeDateTime to CTime

mfc ctime coledatetime
sshah picture sshah · Oct 14, 2011 · Viewed 6.9k times · Source

I am reading a datetime from database in a ColeDateTime format. I want to convert it to CTime to get the date month 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 could I do this?

Thanks in advance.

Answer

djeidot picture djeidot · Oct 20, 2011

The CTime constructor accepts both SYSTEMTIME and DBTIMESTAMP structures, so both these will work:

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

,

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

Related questions

MFC measure function in milliseconds

How can i count the millisecond a certain function (called repeatedly) takes ? I thought of: CTime::GetCurrentTM() before, CTime::GetCurrentTM() after, And then insert the result to CTimeSpan diff = after - before. Finally store that diff to global member that …

Read More
Private and Protected Members : C++

Can someone enlighten me as to the difference between private and protected members in classes? I understand from best practice conventions that variables and functions which are not called outside the class should be made private - but looking at …

Read More
How do you convert CString and std::string std::wstring to each other?

CString is quite handy, while std::string is more compatible with STL container. I am using hash_map. However, hash_map does not support CStrings as keys, so I want to convert the CString into a std::string. Writing a …

Read More