Skip to main content

%Library.FilemanTimeStamp

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

Method Inventory

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
FeedbackOpens in a new tab