mORMot Open Source

wai-kit

Member

From: Amsterdam, the Netherlands

Registered: 2012-11-27

Posts: 90

How to change Date Format in DateTime field?

Hi everyone,

How do I change the format in a datetime field in results returned from ISQLDBRows.FetchAllAsJSON? The datetime fields
returned to my client have the date format, 'mm/dd/yyyy' and I would like to change that to 'dd/mm/yyyy'.

Cheers,
Wai

---

fpcdeluxe, FPC 3.2 / Lazarus 2.0, mORMot on Windows 10 ...

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: How to change Date Format in DateTime field?

The JSON content returned ISO-8601 standard format.
You should NOT change this format, which is expected to be as such everywhere within the framework units.

It is up to the end-user application to change the date format, depending on the local system settings, for instance.