eva/3 Application Builder • Developing eva/3 Applications • Working with expressions
Date
A date is always designated by a prefixed and closing #-character. At double-digit date specification the threshold is defined with 08. Year specifications from 00 till 08
are appendand to the years 200x, 09 till 99 to the years 19xx.
At a date all relational operators can be used.
Beispiel: =#1.1.2005# > #1.1.2004# with the result true
Date and time formats can be spearated using a white space or like defined in ISO8601 the T character.
The date must be at the first part of the date/time string, followed by the time value.
Example: #2003-04-01T13:01:02# or #2003-04-01 13:01:02#
| Name |
Datumsformate |
Beispiel |
|
ISO8601
|
YYYY-MM-DD
|
#2003-04-01# represents the first day in april 2003.
|
|
ISO8601
|
YYYYMMDD (Basisformat)
|
#20030401# represents the first day in april 2003.
|
|
ISO8601
|
YYYY-Www-D
|
#2003-W14-2# represents the decond day at the fourteenth week 2003.
|
|
DIN 5008
|
DD.MM.YYYY od. DD.MM.YY
|
#07.01.2003# represents the seventh day at january 2003.
|
|
|
MM/DD/YYYY od. MM/DD/YY
|
#01/07/2003# represents the seventh day at january 2003.
|
| Name |
Zeitformate |
Beispiel |
|
ISO8601
|
hh:mm:ss
|
#23:59:59# represents the time with one second after midnight.
|
| Name |
Nicht kombinierbare Datum / Zeitformate |
Beispiel |
|
|
YYYY.MM.DD G 'at' hh:mm:ss z
|
#1996.07.10 AD at 15:08:56 PDT#.
|
|
|
EEE MMM DD hh:mm:ss zzz yyyy
|
#Sat Jan 01 12:01:00 CET 2005#.
|
|
W3C
|
yyyy-MM-dd'T'HH:mm:ssz
|
#1997-07-16T19:20:30+01:00#.
|
|
W3C
|
yyyy-MM-dd'T'HH:mmz
|
#1997-07-16T19:20+01:00#.
|
|
W3C
|
yyyy-MM-dd'T'HH:mm:ss.SSSSz
|
#1997-07-16T19:20:30.10+01:00#.
|
For working with date values please take also a look at date functions.
Working with expressions