C++ ParseDateTime() - SQL datetime as UK date

Question

I have dates stored in datetime in an MSSQL database. In my C++ application, these dates are pulled out of the database and stored in a CString.

I am trying to use COleDateTime's ParseDateTime() to display these dates in a nice format. However I found they are being displayed in american format (MM/DD/YYYY), and sorted as such. I would like them displayed in UK format (MM/DD/YYYY). I have attempted the code below to no difference:

codt.ParseDateTime(sqlresults.GetItem(_T("date"),l),0,MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_UK));

Thanks!

Answer 1

The ParseDateTime function is used to read the provided value – in your case you get it from the database and set the internal representation of the COleDateTime object.

You are not after this method but rather after the COleDateTime::Format method.

codt.ParseDateTime(
    sqlresults.GetItem(_T("date"),l),
    0,
    MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US));
CString dateAsUkString = codt.Format(_T("%d/%m/%Y"));
// display the dateAsUkString string in your view