Automatic data file modification: new date format

Help

WLanguage

Managing databases

AS400

Access via ODBC or OLE DB

Big Data

HFSQL functions

Handling a CEDB database

Managing 3-tier architecture

Managing HFSQL Client/Server

Managing HFSQL Cluster

Managing log processes

Managing replications

Automatic data file modification: new date format

Overview

How will the automatic data modification operate?

See also

Accessing HFSQL files via SAMBA on Linux

Accessing the databases: summary

Analysis shared between earlier WINDEV applications and WINDEV 24 applications

Assisted management of HFSQL errors

Automatic data file modification: new date format

Automatic modification of data files

Browsing the HFSQL data files

Communication by GPRS

Connecting to a database via RPC

Errors while managing data files

Filtering a data file, a view or a query

HFSQL data files exceeding 2 gigabytes

HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003

HFSQL management functions

HFSQL management functions (prefix syntax)

HFSQL thumbnails

HFSQL: Change of name

Hyper File functions available for backward compatibility

Locking data files: correspondence between WINDEV 5.5 and the later versions

Management errors specific to Native Accesses

Managing NULL in HFSQL

Managing aliases on the data files

Managing connections

Managing space characters in the searches?

Managing the Unicode format in the HFSQL files

Managing the automatic identifiers when adding a record

Modifying the query content

Native Access access

Native XML Access

Optimizing the remote access

Partial indexing of memos

Remote access (RPC on HFSQL)

SQL functions: Special case

Search and full-text index

Synchronizing data (Windows CE)

The .REP file

The HFSQL views

The composite keys

The different types of browse available in SQL

Unalterable data files

WDModFic : Tool for automatic modification of data files

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

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Automatic modification of data files

Automatic data file modification: 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, used to store both the date and the time: YYYYYMMDDHHHmmSSCCC (precision: Thousandths of a second)
Duration	New format, used to manage the durations: +JHHMMSSCCC (accuracy 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 The time is initialized 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

Remark: For a network setup, the automatic data modification modifies both the data files found on the server and the data files found on the user computers.