Convert time string to SYSTEMTIME

[tbeu]

I have got a time string in special format pattern

Code: Select all

"ddd MMM dd HH:mm:ss yyyy"

. Is there a simple way to convert it back to SYSTEMTIME?

[SanskritFritz]

Delphi? C++? PL/SQL? Python?

[TLis]

Any language could be used, that supports regular expressions. Personally I would use Python, which I like best

If I understand you correctly, that ddd are the weekday shortcuts (Mon, Tue, etc.), and MMM are month name shortcuts (Jan, Feb, etc.), then you could use the proper alternatives in the pattern (e.g. (Mon|Tue|...) )to make the matching more precise. You could use groupings to get the parts of the matched string correspondings to the date elements. Then, before you use the time module functions, you need to translate the month name shortcuts into the month number. As soon, as you get the date, it is possible to translate it back into a string using the strftime function

[tbeu]

C/C++ would be my prefered language.

[HolgerK]

Code: Select all

static const char* Days[]	= { "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat" };
static const char* Months[]	= { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" };

SYSTEMTIME DateString2SYSTEMTIME( char* pstrDate )
{
	SYSTEMTIME systime;
	memset(&systime,0,sizeof(systime));
	char strDay[10];
	char strMonth[10];
	if( 7 == sscanf
			( pstrDate
			, "%3s %3s %d %d:%d:%d %d"
			, strDay
			, strMonth
			, &systime.wDay
			, &systime.wHour
			, &systime.wMinute
			, &systime.wSecond
			, &systime.wYear
			)
		)
	{
		WORD i;
		for( i= 0; i< 7; i++ )
			if( 0 == strcmpi( strDay, Days[i] ) )
				systime.wDayOfWeek	= i;
		for( i= 0; i< 12; i++ )
			if( 0 == strcmpi( strMonth, Months[i] ) )
				systime.wMonth		= WORD(i+1);

		// Time zone correction
		FILETIME ft;
		SystemTimeToFileTime( &systime,  &ft );
		LocalFileTimeToFileTime( &ft, &ft );
		FileTimeToSystemTime(   &ft, &systime );
	}
	return systime;
}

HTH,
Holger

[tbeu]

Thank you, Holger!