%Library.InformixTimeStamp

Class %Library.InformixTimeStamp Extends %DataType [ ClientDataType = TIMESTAMP, OdbcType = TIMESTAMP, Not ProcedureBlock, SqlCategory = TIMESTAMP, System = 2 ]

The %Library.InformixTimeStamp data type class represents a time stamp value.

The logical value of the %Library.InformixTimeStamp data type is in YYYY-MM-DD HH:MM:SS.nnnnnnnnn format.

Parameters

XMLTIMEZONE

Parameter XMLTIMEZONE [ Constraint = "IGNORE,UTC", Flags = ENUM ] = "UTC";

XMLTIMEZONE specifies the handling of timezone part of the XML format dateTime. "UTC" means convert to UTC on input. "IGNORE means ignore the timezone.

XSDTYPE

Parameter XSDTYPE = "dateTime";

Declares the XSD type used when projecting XML Schemas.

JSONTYPE

Parameter JSONTYPE = "string";

LARGEQUAL;

Parameter LARGEQUAL;

The %Library.InformixTimeStamp data type is composed of a contiguous sequence of fields that represents each component of time you want to record and uses the following syntax: DATETIME largest_qualifier TO smallest_qualifier The largest_qualifier and smallest_qualifier can be any one of the fields: Qualifier Field Valid Entries YEAR A year numbered from 1 to 9,999 (A.D.) MONTH A month numbered from 1 to 12 DAY A day numbered from 1 to 31, as appropriate to the month HOUR An hour numbered from 0 (midnight) to 23 MINUTE A minute numbered from 0 to 59 SECOND A second numbered from 0 to 59 FRACTION A decimal fraction of a second with up to 5 digits of precision. The default precision is 3 digits (a thousandth of a second). Other precisions are indicated explicitly by writing FRACTION(n), where n is the desired number of digits from 1 to 5. .

SMALLQUAL;

Parameter SMALLQUAL;

Methods

XSDToLogical

ClassMethod XSDToLogical(%val As %String) As %TimeStamp [ CodeMode = generator, ServerOnly = 1 ]

Converts the SOAP encoded input dateTime value into a %TimeStamp value.

LogicalToXSD

ClassMethod LogicalToXSD(%val As %TimeStamp) As %String [ CodeMode = generator, ServerOnly = 1 ]

Converts the %TimeStamp value to the canonical SOAP encoded value.

Normalize

ClassMethod Normalize(%val As %RawString) As %TimeStamp [ CodeMode = expression, ServerOnly = 1 ]

Transforms integer values into timestamp.

IsValid

ClassMethod IsValid(%val As %RawString) As %Status [ CodeMode = generator, ServerOnly = 0 ]

Tests if the logical value %val, which represents an Informix Timestamp value in YYYY-MM-DD HH:MM:SS[.nnnnn] format, is valid. Valid formats include: - TimeStamp value in the format YYYY-MM-DD HH:MI:SS[.nnnnn] - Integer value that represents +$Horolog, will be converted to the date portion of the Informix TimeStamp value - Time value of the form HH:MM:SS[.nnnnn], will default the date portion of the Informix Timestamp to today's date - Date value in the format YYYY-MM-DD, , will be converted to the date portion of the Informix TimeStamp value