Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%Library] >  [InformixTimeStamp]
Private  Storage   

datatype class %Library.InformixTimeStamp extends %DataType

ODBC Type: TIMESTAMP

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.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
5 4


Summary

Methods
IsValid LogicalToXSD Normalize XSDToLogical


Parameters

• parameter JSONTYPE = "string";
• 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. .
• parameter SMALLQUAL;
• parameter XMLTIMEZONE = "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.
• parameter XSDTYPE = "dateTime";
Declares the XSD type used when projecting XML Schemas.

Methods

• classmethod IsValid(%val As %RawString) as %Status
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
• classmethod LogicalToXSD(%val As %TimeStamp) as %String
Converts the %TimeStamp value to the canonical SOAP encoded value.
• classmethod Normalize(%val As %RawString) as %TimeStamp
Transforms integer values into timestamp.
• classmethod XSDToLogical(%val As %String) as %TimeStamp
Converts the SOAP encoded input dateTime value into a %TimeStamp value.


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.