15.105 SEM_APIS.GETV$DATETIMETZVAL
Format
SEM_APIS.GETV$DATETIMETZVAL( value_type IN VARCHAR2, vname_prefix IN VARCHAR2, vname_suffix IN VARCHAR2, literal_type IN VARCHAR2, language_type IN VARCHAR2, ) RETURN NUMBER;
Description
Returns a TIMESTAMP WITH TIME ZONE value for xsd:dateTime typed literals, and returns a null value for all other RDF terms. Greenwich Mean Time is used as the default time zone for xsd:dateTime 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:dateTime literals in the RDF_VALUE$ table:
SELECT SEM_APIS.GETV$DATETIMETZVAL(value_type, vname_prefix, vname_suffix, literal_type, language_type) FROM RDF_VALUE$;
Parent topic: SEM_APIS Package Subprograms