Package dev.frostlake.functions.scalar.conversion

Class TryToTimestamp

java.lang.Object

dev.frostlake.functions.BuiltInFunction

dev.frostlake.functions.scalar.conversion.TryToTimestamp

public class TryToTimestamp
extends BuiltInFunction

TRY_TO_TIMESTAMP / _NTZ / _LTZ / _TZ — the non-throwing form of TO_TIMESTAMP: the same conversion into the same flavour's value (see TimestampFlavourConversion), NULL instead of a refusal for input it cannot read. The source must be text — a NUMBER is refused while the statement compiles, as TRY_CAST refuses it — so a string of digits is the only epoch it meets.

Constructor Summary

Constructors

Constructor	Description
TryToTimestamp()
TryToTimestamp(String name)

Method Summary

Modifier and Type	Method	Description
Object	evaluate(List<Object> args)	Computes the function's result over its already-evaluated argument values.
int	getMaxArgCount()	The most arguments a call to this function may pass; Integer.MAX_VALUE marks a variadic function (see BuiltInFunction.isVariadic()).
int	getMinArgCount()	The fewest arguments a call to this function may pass; fewer is an argument-count error.
DataType	getReturnType()	The BARE spelling follows the session's TIMESTAMP_TYPE_MAPPING, re-resolved on every call as TO_TIMESTAMP's is: the registry builds each function once, before any session exists.

Methods inherited from class dev.frostlake.functions.BuiltInFunction

approximateRejection, binaryRejection, booleanRejection, evaluate, fileRejection, geoRejection, getName, isVariadic, refusesMissingArgumentsByType, semiStructuredRejection, structuredRejection, temporalRejection, temporalRejection, temporalRejection, textRejection, uuidRejection, vectorRejection

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

TryToTimestamp

public TryToTimestamp()

TryToTimestamp

public TryToTimestamp(String name)

Method Details

getReturnType

public DataType getReturnType()

The BARE spelling follows the session's TIMESTAMP_TYPE_MAPPING, re-resolved on every call as TO_TIMESTAMP's is: the registry builds each function once, before any session exists.

Overrides:

getReturnType in class BuiltInFunction

evaluate

public Object evaluate(List<Object> args)

Description copied from class: BuiltInFunction

Computes the function's result over its already-evaluated argument values. A SQL NULL argument arrives as Java null, and returning null makes the SQL result NULL.

Specified by:

evaluate in class BuiltInFunction

Parameters:

args - the argument values, in call order

Returns:

the function's value for these arguments, or null for SQL NULL

getMinArgCount

public int getMinArgCount()

Description copied from class: BuiltInFunction

The fewest arguments a call to this function may pass; fewer is an argument-count error.

Specified by:

getMinArgCount in class BuiltInFunction

Returns:

the minimum accepted argument count

getMaxArgCount

public int getMaxArgCount()

Description copied from class: BuiltInFunction

The most arguments a call to this function may pass; Integer.MAX_VALUE marks a variadic function (see BuiltInFunction.isVariadic()).

Specified by:

getMaxArgCount in class BuiltInFunction

Returns:

the maximum accepted argument count