Need faster replacement for COleDateTime::Format()

[scott meyer]

I have an app which manipulates a lot of dates (reading from a database).

It uses the Format() member function of COleDateTime extensively.

During a recent profiling session, it became apparent that a large amount of my app's time is spent in the Format() function.

Here's how I'm using it:

COleDateTime date1 = x.Format("%m/%d/%Y");

Simple, yes. But very expensive in terms of CPU time.

Does anyone have a faster way to do this?

[mwilliamson]

try this:

std::stringstream x;
x << date1.GetMonth() << "/" << date1.GetDay() << "/" << date1.GetYear();

[scott meyer]

should have been:

I have an app which manipulates a lot of dates (reading from a database).

It uses the Format() member function of COleDateTime extensively.

During a recent profiling session, it became apparent that a large amount of my app's time is spent in the Format() function.

Here's how I'm using it:

CString date1 = x.Format("%m/%d/%Y");

(x is a COleDateTime variable)

Simple, yes. But very expensive in terms of CPU time.

Does anyone have a faster way to do this?

[mwilliamson]

Why not have the provider convert it to a string for you? When binding you accessor just change the type to DBTYPE_STR.

[scott meyer]

For this discussion, let's forget that the values are in a database.

I still have to do a lot of format()s outside of the database access stuff.

And the OLE DB library I use requires me to read dates as dates, not as strings.