#1 2014-01-07 09:59:58

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 ...

Offline

#2 2014-01-07 14:47:48

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,183
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.

Offline

Board footer

Powered by FluxBB