Timestamp Data Type

CA Gen does not support the Timestamps With Time Zone data type and the use of explicit C-type timestamp casting in an input value. All CA Gen timestamps, and timestamp input values, are considered to be of the Timestamp Without Time Zone data type.

The following table displays the formats used to specify a value for a data type of Timestamp Without Time Zone

Note:

1. No fractional seconds; shown with and without optional trailing period after seconds.
2. p is the number of digits of fractional seconds. nnnnnnnnnnnn can range from 1 to 12 instances of n.
3. As an additional format, the character T can be substituted as the separator between the date and time portions of the value.

The following rules apply for timestamp data type inputs:

• A string representation of a timestamp is a character or graphic string that starts with a digit and has a length of at least 16 characters.
• The character or graphic string must contain a value that conforms to one of the formats listed in Datetime constants and is subject to the following rules:
  • Leading blanks are not permitted.
  • Trailing blanks can be included.
  • Leading zeros are omitted from the month, day, and hour elements of the timestamp. An implicit specification of 0 is assumed for any digit that is omitted.
  • The hour can be 24 if the minutes, seconds, and any fractional seconds are all zeroes.
  • Leading zeros must be included for the minute, and second elements of the timestamp.
  • The number of digits of fractional seconds can vary from 0 to 12. An implicit specification of 0 is assumed if fractional seconds are omitted.
  • The separator character that follows the seconds element can be omitted if fractional seconds are not included.

SQL statements also support the ODBC or JDBC string representation of a timestamp as an input value only. The ODBC and JDBC string representation of a timestamp has the form yyyy-mm-dd hh:mm:ss.nnnnnn.