Datetime Intrinsic Functions

Datetime Intrinsic Functions (PRIM_LIBI.IDateTimeIntrinsics)

Datetime intrinsic functions

Ancestors - None

Details

Container for all date time intrinsic functions

Methods

Name	Description
AsCustomDisplayString	Returns the date in a user defined format Result, DateFormat, TimeFormat
AsDisplayString	Convert the variable to a formatted string Result, Format
AsDuration	Convert to an ISO standard duration Result, Starting
AsGregorianDay	Returns the variable in Gregorian day format Result
AsGregorianMonth	Returns the variable in Gregorian month format Result
AsGregorianMonthDay	Returns the variable in Gregorian month day format Result
AsGregorianYear	Returns the variable in Gregorian year format Result
AsGregorianYearMonth	Returns the variable in Gregorian year month format Result
AsLocalizedDateTime	Return the variable adjust for locale Result
AsNumber	Return the variable as a number Result, Format
AsSeconds	Return the variable as the number since midnight Result
AsString	Return the variable as a string Result
AsUniversalDateTime	Return the variable as a universal datetime Result
AsValue	Return the variable as a value if SQLNull Result, Default
Date	Return the date portion of the datetime Result
FractionalSeconds	Return the partial second portion of the time Result
IsNotSqlNull	Test if the variable is not SQLNull Result
IsNull	Test if the variable is a LANSA null Result
IsSqlNull	Test if the variable is SQLNull Result
Max	Returns the latest datetime Result, DateTime1, DateTime2, DateTime3, DateTime4, DateTime5, DateTime6, DateTime7, DateTime8, DateTime9
Min	Returns the earliest datetime Result, DateTime1, DateTime2, DateTime3, DateTime4, DateTime5, DateTime6, DateTime7, DateTime8, DateTime9
Now	Return the current datetime Result
Time	Return the time portion of the datetime Result

Details

Methods

See also