How to parse date/time from string?

Question

Input: strings with date and optional time. Different representations would be nice but necessary. The strings are user-supplied and can be malformed. Examples:

• "2004-03-21 12:45:33" (I consider this the default layout)
• "2004/03/21 12:45:33" (optional layout)
• "23.09.2004 04:12:21" (german format, optional)
• "2003-02-11" (time may be missing)

Needed Output: Seconds since Epoch (1970/01/01 00:00:00) or some other fixed point.

Bonus: Also, reading the UTC-offset of the local system time would be great.

The input is assumed to be a local time on the machine in question. The output needs to be UTC. System is Linux only (Debian Lenny and Ubuntu needed).

I have tried to use boost/date_time, but must admit I can't wrap my head around the documentation. The following works without the needed conversion from system local time to UTC:

std::string date = "2000-01-01";
boost::posix_time::ptime ptimedate = boost::posix_time::time_from_string(date);
ptimedate += boost::posix_time::hours(Hardcoded_UTC_Offset);// where to get from?
struct tm = boost::posix_time::to_tm(ptimedate);
int64_t ticks = mktime(&mTmTime);

I think boost::date_time can provide the needed UTC offset, but I wouldn't know how.

Answer 1

Although I don't know how to format a single-digit month input in boost, I can do it after the two-digit edit:

#include <iostream> #include <boost/date_time.hpp> namespace bt = boost::posix_time; const std::locale formats[] = { std::locale(std::locale::classic(),new bt::time_input_facet("%Y-%m-%d %H:%M:%S")), std::locale(std::locale::classic(),new bt::time_input_facet("%Y/%m/%d %H:%M:%S")), std::locale(std::locale::classic(),new bt::time_input_facet("%d.%m.%Y %H:%M:%S")), std::locale(std::locale::classic(),new bt::time_input_facet("%Y-%m-%d"))}; const size_t formats_n = sizeof(formats)/sizeof(formats[0]);  std::time_t pt_to_time_t(const bt::ptime& pt) {     bt::ptime timet_start(boost::gregorian::date(1970,1,1));     bt::time_duration diff = pt - timet_start;     return diff.ticks()/bt::time_duration::rep_type::ticks_per_second;  } void seconds_from_epoch(const std::string& s) {     bt::ptime pt;     for(size_t i=0; i<formats_n; ++i)     {         std::istringstream is(s);         is.imbue(formats[i]);         is >> pt;         if(pt != bt::ptime()) break;     }     std::cout << " ptime is " << pt << '\n';     std::cout << " seconds from epoch are " << pt_to_time_t(pt) << '\n'; } int main() {     seconds_from_epoch("2004-03-21 12:45:33");     seconds_from_epoch("2004/03/21 12:45:33");     seconds_from_epoch("23.09.2004 04:12:21");     seconds_from_epoch("2003-02-11"); } 

note that the seconds-from-epoch output will be assuming the date was in UTC:

~ $ ./test | head -2 ptime is 2004-Mar-21 12:45:33 seconds from epoch are 1079873133 ~ $ date -d @1079873133 Sun Mar 21 07:45:33 EST 2004 

You could probably use boost::posix_time::c_time::localtime() from #include <boost/date_time/c_time.hpp> to get this conversion done assuming the input is in the current time zone, but it is rather inconsistent: for me, for example, the result will be different between today and next month, when daylight saving ends.

Answer 2

boost::gregorian has some of the stuff you need without you doing any more work:

using namespace boost::gregorian; {   // The following date is in ISO 8601 extended format (CCYY-MM-DD)   std::string s("2000-01-01");   date d(from_simple_string(s));   std::cout << to_simple_string(d) << std::endl; } 

There is an example on how to use UTC offsets with boost::posix_time here.

You can provide generation of date and time from custom input string formats using date_input_facet and time_input_facet. There is an I/O tutorial on this page that should help you get going.

Answer 3

If c-style is acceptable: strptime() is the way to go, because you can specify the format and it can take locale in account:

tm brokenTime;
strptime(str.c_str(), "%Y-%m-%d %T", &brokenTime);
time_t sinceEpoch = timegm(brokenTime);

Different layouts will have to be checked with the return value (if possible). Timezone will have to be added to by checking the system clock (localtime_r() with time(), tm_zone)