Spotfire Ideas Portal
Add a new idea Subscribe
Status Planning to implement
Product Spotfire Data Virtualization
Categories data sources
Created by Guest
Created on Feb 28, 2024

RELATED IDEAS

Push down TDV TZCONVERTOR function to Oracle DB 

The following function when added to Oracle capabilities help push down TZCONVERTOR to Oracle db - 
TZCONVERTOR(@timestamp,~string,~string): cast(from_tz($1, $2) at time zone $3 as TIMESTAMP)

Sample query - 
SELECT TZCONVERTOR (parse_timestamp('2023-03-29 00:30:00.000', 'yyyy-mm-dd hh24:mi:ss.ff3'), 'GMT', 'MST') a0001 
FROM /shared/Oracle19c/TESTUSER/TT_03_120956_L

FETCH node -

SQL:

SELECT
cast(from_tz(TO_TIMESTAMP( '2023-03-29 00:30:00.000', 'yyyy-mm-dd hh24:mi:ss.ff3'), 'GMT') at time zone 'MST' as TIMESTAMP) AS "a0001"
FROM "TESTUSER"."TT_03_120956_L"

 
Oracle doc for FROM_TZ - https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FROM_TZ.html#GUID-84384FF7-6462-480C-BC40-60087016857B
TDV doc for TZCONVERTOR - https://docs.tibco.com/pub/tdv/8.6.0/doc/html/en-US/StudioHelp/index.html#page/StudioHelp%2FAppendix_C_Time_Zones.html
The source and the target timezone should both be supported by the Oracle function and TDV function for it to deliver results.
  • Attach files
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us