HP Neoview Release 2.3 Software - Manual (Page 31)

— space
— tab
— comma (,)
— semicolon (;)
— slash (/)
— backslash (\\)
Period (.) is the only supported separator between integral and fractional seconds.
The following are defaults and examples:
— Date values
◦ Default: %C%y-%m-%d
◦ Example: The input characters “2007–10–05” can be processed without a format
definition and is interpreted as October 5, 2007.
— Time values
◦ Default: %H:%M:%s
◦ Example: The input characters “13:32:00” can be processed without a format
definition and is interpreted as 1:32 p.m.
— Timestamp values
◦ Default: %C%y-%m-%d %H:%M:%S
◦ Example: The input characters “2007–10–05 13:32:00.000000” can be processed
without a format definition and is interpreted as 1:32 p.m on October 5, 2007.
• Interval data types
Interval data types require a formatstring.
There is no default for interval fields.
These field specifiers are allowed:
— For year-month ranges:
◦ %Y — year
◦ %M — month
— For day-time ranges:
◦ %D — day
◦ %H — hour
◦ %M — minutes
◦ %S — seconds (can include fractional seconds)
The values for specifiers must be positive integers.
Specifiers must appear in order from day to seconds. For example, %M (minutes) cannot
precede %H (hours).
Negative interval values always have a minus sign to the left of the integers, with no
spaces between the minus sign and the integers.
The supported field delimiters are:
— hyphen (-) for year-month ranges
— colon (:) for day-time ranges
Examples are:
— To specify a formatstring for a year-month duration of 3 years and 2 months
formatted as “3-2”:
“%Y-%M”
— To specify a formatstring for a year-month duration of 10 years formatted as
“10”:
Control File Organization and Syntax 31