Get date format from a ClientDataset

Posted on 2011-09-04
Last Modified: 2012-05-12
Hi all.
I'm writing a small app - I only write small apps :-) - to write an sql dump file from a ClientDataset. I'm now trying to convert dates. So, assunming in MySql I have to insert values in the following format


I wish to know how to get the format date are stored within ClientDataset. Since this format depends on locxal settings I can have in date field a string like 'dd/mm/yyyy', or 'mm/dd/yyyy' and so on. I should be able to get the actual date format within ClientDataset in order to convert that date in the format 'yyyy-mm-dd' (I solved yet the problem of slashes and dashes using AnsiReplaceText function)

Thanks to all for any help.

Question by:Marco Gasi
  • 4
  • 4
LVL 13

Expert Comment

ID: 36480574
Use getdateformat
It is a windows API.


LVL 13

Expert Comment

ID: 36480584
procedure TForm1.Button1Click(Sender: TObject);
  lSystemTime : TSystemTime;
  lBuffer : array[0..64] of Char;
  lErrorCode : Integer;
  FillChar(lSystemTime, sizeof(TSYSTEMTIME), #0);
  lSystemTime.wDay := 25;
  lSystemTime.wMonth := 8;
  lSystemTime.wYear := 2004;

  if GetDateFormat(LOCALE_USER_DEFAULT, DATE_SHORTDATE, @lSystemTime, nil,
    lBuffer, sizeof(lBuffer)) <> 0 then
LVL 31

Author Comment

by:Marco Gasi
ID: 36480636
Thanks for your reply.

Let me explain better. My app doesn't know anything about ClientDataset it's going to migrate in mysql dump file. It get field type iterating through the dataset opened by user. If it encounter date field it has to know which formt that value use. Theorically, user could be swedish but it could try to convert a dataset filled with an US format. I can't assume that dataset format corresponds to system locale. So, if ClioentDataset doesn't hold any information about date field format, maybe I have to use some regular expression to understand wich format date field use...

I'm wrong?
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

LVL 13

Expert Comment

ID: 36480694
If user could be swedish, is he/she using computer in USA?

If so, ClientDataset will not hold any format info by default within the same date field.
If you know how many different formats you will be supporting, you could add one extra field and have format stored as string.

LVL 100

Expert Comment

ID: 36480717
How is the CLientDataSet created?

LVL 31

Author Comment

by:Marco Gasi
ID: 36480796
I'm tryin to write a progam to allow to anyone to create a mysql dump file from any ClientDataset. It should be an utility for Delphi programmers who need to migrate some MyBase database to mysql, so I can't to know how a ClientDataset is created, nor I can create any extra field.

Perhaps I could let the user tells date format used by selecting it from a combobox... Or I could try to get string and trhen chenge its format using regular expression. The problem is not the creation opf the dump file: this is yet done. But when I tried to import with PhpMyAdmin, date format has not been recognized and all dates have been wrote as '0000-00-00' in the mysql database.

Any idea?
LVL 13

Expert Comment

ID: 36480841
You could add Calculated field to ClientDataset at runtime.

Then use calculated field to determine which format to use to show date.

LVL 31

Accepted Solution

Marco Gasi earned 0 total points
ID: 36480883
Sorry, but it was a trivial task: iterating throught the dataset, I can just use

value := QuotedStr(FormatDateTime('yyyy-mm-dd', StrToDate(Fields.Fields[x].AsString)));

where value is the string that will be written in the value clause of sql statement INSERT

I'm going to ask to close this question. I'm very sorry for having wasted your time: hope youìll excuse me.

Thanks for having tried to help me.
LVL 31

Author Closing Comment

by:Marco Gasi
ID: 36508820
I solved my problem by myself because I understood that it was trivial.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi component that can load a DLL in design time? 8 59
Printing problem 2 91
Delphi Form ownership 4 85
tvirtualstringtree freeze when load too manny images 10 60
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now