Insert timestamp with timezone in database
14 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Christian
le 26 Juil 2021
Commenté : Christian
le 30 Juil 2021
Hi,
I'd like to insert (table) data into an Oracle database. The data contains datetime variables with timezone information which should be inserted into a oracle table with type timestamp with timezone.
sqlwrite (or similar) function can add/transform datetime to timestamp (oracle), but not to timestamp with timezone. The only workaround I've found is a direct linewise exec insert sql statement (insert into table () values ().... ) whereas datetime timezone is set to UTC and is formatted like
strcat('to_timestamp_tz(''', datestr(tbl.TS ,'dd.mm.yyyy HH:MM'), ' 00:00'', ''dd.mm.yyyy HH24:MI TZH:TZM'')')
Not very elegant and fast...
I'm using R19b.
Thanks for any hints...
Christian
0 commentaires
Réponse acceptée
Shadaab Siddiqie
le 30 Juil 2021
From my understanding you want to insert timestamp with time zone in database. Since this is some sort of custom format that you want inserted into your database from my understanding you must create a workaround it (as you have already done) and there might not be another elegant way to do it.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!