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


See also

All Component Classes

Technical Reference

  • No labels