Home > Class Reference > %SYS namespace > %Library.FilemanTimeStamp

%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 [ Language = objectscript ]
Converts DISPLAY format TIMESTAMP (MM/DD/YYYY HH:MM:SS) to FILEMAN format TimeStamp (CYYMMDD.HHMMSS).
classmethod IsValid(%val As %RawString) as %Status [ Language = objectscript ]
Checks for Invalid Format, expects FILEMAN format TimeStamp (CYYMMDD.HHMMSS).
classmethod LogicalToDisplay(Arg1 As %Library.FilemanTimeStamp = "") as %Library.String [ Language = objectscript ]
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 [ Language = objectscript ]
Converts FILEMAN format TimeStamp (CYYMMDD.HHMMSS) to ODBC format TIMESTAMP (YYYY-MM-DD HH:MM:SS)
classmethod LogicalToXSD(%val As %FilemanTimeStamp) as %String [ Language = objectscript ]
Converts the %FilemanTimeStamp value to the canonical SOAP encoded value.
classmethod OdbcToLogical(Arg1 As %Library.String) as %Library.FilemanTimeStamp [ Language = objectscript ]
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 [ Language = objectscript ]
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 [ Language = objectscript ]
FeedbackOpens in a new window