Change any form of date time string format into US date time format using C++

Question

1.00/5 (1 vote)

See more:

Hi Guys,

currently i am dealing with 71 type of date time format, i want all this format to be converted into US date time format.
example:
input:
datetime format 1:
dddd, dd MMMM, yyyy h:mm:ss tt
monday,17 october 1992 4:32:28

datetime format 2:
dd MMMM yyyy h:mm:ss tt
17 october 1992 4:32:28

date time format 3:
MM/DD/YYYY at HH:mm:ss
10/17/1992 at 4:32:28

all above format must get converted and printed into below given format using C++
output : dddd, MMMM dd, yyyy h:mm:ss tt (this is US time format)
monday, october 17 1992 4:32:28

Hey i am very much sure that this code works well on US and UK system. but same doesnot works properly on spanish, dutch , france system

What I have tried:

Currently i am manually converting and inserting time into US Format which is very tiresome

Posted 29-Mar-16 21:11pm

Member 12361678

Updated 4-Apr-16 2:24am

v4

Add a Solution

Comments

phil.o 30-Mar-16 3:22am

Formatting a DateTime has to be done only on the user interface; at the data storage level, datetimes should be stored as the relevant datatype (datetime, datetime2, ...), not strings.

You did not tell much in your post, and you did not ask a formal question either. It will be difficult to get a specific answer without more precisions from your part.

Jochen Arndt 30-Mar-16 3:47am

If you have a datetime string and want to convert it to a datetime value you need information about the used format. Without that information not all strings can be converted because format detections will not work for all possible variations. If the strings contain also day and/or month names, you will also have to support all possible languages. So this will be a quite extensive task and requires manual check afterwards for the cases where the detection is not distinct.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KarstenK · Answer 1 · 2016-04-03T21:50:00

Your problem is the typical use case for the functions strptime for parsing the textual date and and strftime for formatting the output.
The code for strptime can be found also here.
The rest is some code writing. But be aware: you must detect yourself which pattern to use. Write some tests for check the robustness of your solution.