15.106 SEM_APIS.GETV$DATETZVAL
Format
SEM_APIS.GETV$DATETZVAL( value_type IN VARCHAR2, vname_prefix IN VARCHAR2, vname_suffix IN VARCHAR2, literal_type IN VARCHAR2, language_type IN VARCHAR2, ) RETURN TIMESTAMP WITH TIME ZONE;
Description
Returns a TIMESTAMP WITH TIME ZONE value for xsd:date typed literals, and returns a null value for all other RDF terms. Greenwich Mean Time is used as the default time zone for xsd:date values without time zones.
Parameters
Usage Notes
For better performance, consider creating a function-based index on this function. For more information, see Function-Based Indexes for FILTER Constructs Involving Typed Literals.
Examples
The following example returns TIMESTAMP WITH TIME ZONE values for all xsd:date literals in the RDF_VALUE$ table:
SELECT SEM_APIS.GETV$DATETZVAL(value_type, vname_prefix, vname_suffix, literal_type, language_type) FROM RDF_VALUE$;
Parent topic: SEM_APIS Package Subprograms