- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
CDB/PDB versus SYSDATE -- can i make them play nice?
I am migrating from a single database 11g configuration to a multitenant 12c (12.1) database. I have a CDB set up with one timezone (PST) and a PDB set up with a different time zone (CDT). We have verified this using the dbtimezone function.
Of course I migrated a my code over to the PDB and gave it a go.
SYSDATE is returning the CDB PST time (select sysdate from dual) when I'm in the PDB. I'm guessing we messed something up in the PDB configuration? Surely any PL-SQL or SQL can be made to function with the time zone of each PDB -- otherwise why have it?