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

datatype class %Library.FilemanTimeStamp

ODBC Type: TIMESTAMP

Custom TimeStamp datatype designed to handle internal FILEMAN format TimeStamp (CYYMMDD.HHMMSS). This data type projects proper TIMESTAMP meta data to DISPLAY and ODBC Client software. It does not require any extra routines to function

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
3 8


Summary

Methods
DisplayToLogical IsValid LogicalToDisplay LogicalToOdbc
LogicalToXSD OdbcToLogical StorageToLogical XSDToLogical


Parameters

• parameter JSONTYPE = "string";
• parameter STRICTDATA = 0;
1/0 flag which determines if the LogicalToFormat conversions will process imprecise logical FileMan Date values Default setting is STRICTDATA=0 Parameter affects the generation of the LogicalToDisplay and LogicalToOdbc methods When STRICTDATA=1, imprecise or invalid dates will not be changed to a valid FileMan Date value. For example, if Logical FileMan Date value is 31110, when STRICTDATA=0 this will translate to 3111001 (Sept 01, 2011). If STRICTDATA=1, this transformation will not take place and the invalid/imprecise Logical value will get an error when converted to Display or Odbc format.
• parameter XSDTYPE = "dateTime";

Methods

• classmethod DisplayToLogical(Arg1 As %Library.String) as %Library.FilemanTimeStamp
Converts DISPLAY format TIMESTAMP (MM/DD/YYYY HH:MM:SS) to FILEMAN format TimeStamp (CYYMMDD.HHMMSS).
• classmethod IsValid(%val As %RawString) as %Status
Checks for Invalid Format, expects FILEMAN format TimeStamp (CYYMMDD.HHMMSS).
• classmethod LogicalToDisplay(Arg1 As %Library.FilemanTimeStamp = "") as %Library.String
Checks for Invalid Format, expects FILEMAN format TimeStamp (CYYMMDD.HHMMSS). Converts FILEMAN format TimeStamp (CYYMMDD.HHMMSS) to DISPLAY format TIMESTAMP (DD/MM/YYYY HH:MM:SS).
• classmethod LogicalToOdbc(Arg1 As %Library.FilemanTimeStamp) as %Library.String
Converts FILEMAN format TimeStamp (CYYMMDD.HHMMSS) to ODBC format TIMESTAMP (YYYY-MM-DD HH:MM:SS)
• classmethod LogicalToXSD(%val As %FilemanTimeStamp) as %String
Converts the %FilemanTimeStamp value to the canonical SOAP encoded value.
• classmethod OdbcToLogical(Arg1 As %Library.String) as %Library.FilemanTimeStamp
Converts ODBC format TIMESTAMP (YYYY-MM-DD HH:MM:SS) to FILEMAN format TimeStamp (CYYMMDD.HHMMSS)
• classmethod StorageToLogical(%val As %Library.String) as %Library.FilemanTimeStamp
Converts Storage FileMan TIMESTAMP (CYYMMDD.HHMMSS) with possible trailing 0's to a Logical canonical value without trailing 0's This is needed so that values with trailing zeros and without can all be compared with ]] properly (they will all be treated as numeric values). LogicalTo**** methods will handle the missing trailing zeros to produce the correct time
• classmethod XSDToLogical(%val As %String) as %FilemanTimeStamp


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