How to convert date and time in different formats?

Question

Data I am having

I have a data stored in database which has a date and time stored as a string.

This data is stored at the central server. In this data the date and time has been stored in different formats (varies as per the client machines date time format).

I wanted to do

Now, I want to convert these all different formatted date and time strings to "yyyy-mm-dd hh:mm:ss" format.

Problem I am facing

I am not able to convert date-time data with multiple date time format to a single format.

Example: My machine date time format is yyyy-mm-dd. but when I am trying to convert the date below

StrToDateTime('2015/02/10')

It throws an exception.

Can any one tell me how I can achieve that? Please let me know if any more details are required. Thank you in advance.

Answer 1

You need custom date format settings, like that:

procedure Test;
var
  DT: TDateTime;
  FS: TFormatSettings;

begin
  FS:= TFormatSettings.Create;
  FS.DateSeparator:= '/';
  FS.ShortDateFormat:= 'yy/m/d';
  DT:= StrToDateTime('2015/02/10', FS);
  Writeln(FormatDateTime('dd mm yyyy', DT));
end;