Kbase P99163: What is ISO 8601?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/12/2004 |
|
Status: Unverified
GOAL:
What is ISO 8601?
GOAL:
ISO-DATE function
FACT(s) (Environment):
OpenEdge 10
FIX:
International Standard ISO 8601 specifies numeric representations of date and time.
This standard notation helps to avoid confusion in international communication caused by the many different national notations and increases the portability of computer user interfaces.
In addition, these formats have several important advantages for computer usage compared to other traditional date and time notations.
The time notation described here is already the de-facto standard in almost all countries and the date notation is becoming increasingly popular.
With Progress OpenEdge 10:
Regardless of how you display and enter time data, you should store it using one of the DATE, DATETIME, or DATETIME-TZ data types.
You can use the ISO-DATE Function, Returns a character representation of a DATE, DATETIME , or DATETIME-TZ that conforms to the ISO 8601 standard for date/time representations. These formats are equivalent to the XML Schema date and dateTime formats.
For more information about ISO 8601 see: http://www.cl.cam.ac.uk/~mgk25/iso-time.html
See Solution: How to get a date in the ISO 8601 standard format?