a
List of Integer, Time and Date Formats
Date and time data needs to be passed to the AltioLive Presentation Server in the following format from your application.
For the TIMESTAMP element, if the FORMAT attribute is left blank or is set to '#' then the Timestamp attribute is read "as is". For example, an attribute value of 5435 produces a timestamp of 5435. This should cater for most cases where an integer timestamp is provided. If the integer needs to be extracted from an attribute with other symbols present then the FORMAT attribute specifies how to extract an integer.
Here is a list of the special characters that can be listed in an Integer Format:
|
Symbol |
Meaning |
|
0 |
Digit |
|
# |
Digit, zero shows as absent |
|
. |
Decimal separator or monetary decimal separator |
|
- |
Minus sign |
|
, |
Grouping separator |
|
E |
Separates mantissa and exponent in scientific notation. |
|
' |
Used to quote special characters in a prefix or suffix.
|
Other characters are matched literally so examples are:
'_#' would interpret '_12345' as 12345
'id'-'#' would interpret 'id-12345' as 12345
Format is mandatory for a Date type.
Some examples of valid formats are:
'MM.dd.yyyy hh:mm:ss a' for a US date separated with dots, with a 4 digit year and 12 hour time format, followed by AM/PM. For example: '06.20.2001 10:03:57 PM'
'dd/MM/yy HH:mm:ss' for an European date with a 2 digit year, and time given in 24 hour format. For example: '20/4/01 22:03:57'
Here is a list of the symbols that can be used in a Date Format string:
|
Symbol |
Meaning |
Presentation |
Example |
|
G |
era designator |
(Text) |
AD |
|
y |
year |
(Number) |
2008 |
|
M |
month in year |
(Text & Number) |
June & 08 |
|
d |
day in month |
(Number) |
3 |
|
h |
hour in am/pm (1~12) |
(Number) |
12 |
|
H |
hour in day (0~23) |
(Number) |
22 |
|
m |
minute in hour |
(Number) |
30 |
|
s |
second in hour |
(Number) |
50 |
|
S |
millisecond |
(Number) |
978 |
|
E |
day in week |
(Text) |
Wednesday |
|
D |
day in year |
(Number) |
189 |
|
F |
day of week in month |
(Number) |
2 (2nd Wed in July) |
|
w |
week in year |
(Number) |
27 |
|
W |
week in month |
(Number) |
3 |
|
a |
am/pm marker |
(Text) |
PM |
|
k |
hour in day (1~24) |
(Number) |
24 |
|
K |
hour in am/pm (0~11) |
(Number) |
11 |
|
z |
time zone |
(Text) |
Pacific Standard Time |
|
' |
escape for text |
(Delimiter) |
|
|
" |
single quote |
(Literal) |
' |