Automatic modification of data files: new date format

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / Automatic data modification

Overview
From WINDEV 7 and WEBDEV 7 version 149
How will the automatic data modification operate?

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Automatic data file modification

Automatic modification of data files: new date format

Available only with this kind of connection

Overview

From WINDEV 7 and WEBDEV 7 version 149

From now on, the following formats are available for the dates and times stored in items:


Format available for the items	Description
Date in YYYYMMDD format	Date format available in WINDEV 5.5, WINDEV 7.5 and later versions.
Date and Time	New date format, allowing both date and time to be stored: YYYYMMDDHHmmSSCCC (precision: thousandths of a second)
Duration	New format for managing durations: +JHHMMSSCCC (precision: thousandths of a second)
Time in HHMM format	Time format available in WINDEV 5.5, WINDEV 7.5 and later versions.

How will the automatic data modification operate?

Conversion table when going from the "old format" to a new format during the automatic modification of data files.


New format	Time	Date	Date/Time	Duration	String / Binary / Memo	Numeric and currency
Old format	Time	Date	Date/Time	Duration	String / Binary / Memo	Numeric and currency
Time	X	0	Date/Time The time is initialized with the value The date is initialized to 00/00/00 (invalid date)	Duration	String	0
Date	0	X	Date/Time Time set to 00: 00 The date is initialized with the value	0	String	0
Date/Time	Time	Date	X	0	String	0
Duration	Time	0	Date/Time The time is initialized with the value The date is initialized to 00/00/00 (invalid date)	X	String	0
String/Binary/Memo	Time	Date	0	0	X	Language conversion
Numeric and currency		0	0	Duration	String	X

Note In the case of a network installation, automatic data modification modifies both the data files on the server workstation and those on the user workstations.