Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Warehouse support the Oracle 9i TIMESTAMP data type ?

April 26, 2017Data Oracle support TIMESTAMP type warehouse

0

Posted

Does Warehouse support the Oracle 9i TIMESTAMP data type ?

1 Answer

0

Posted

As of the 2.07.3140 release, Warehouse supports the Oracle 9i TIMESTAMP data type. This data type is defined internally to Warehouse as an ORACLE TIMESTAMP and represents a date and time to a nanosecond of precision. An ORACLE TIMESTAMP is an 11-byte value where bytes 1-7 are the same as an ORACLE DATE, and bytes 8-11 represent the nanosecond within the second expressed using a 32 integer in big-endian format What are transactional flat files ? (2.07.3140) Flat files now support COMMIT and ROLLBACK. A TEXT, FIXED, or CSV type file opened with mode “!wc+” will now participate commit and rollback transaction processing. This capability is implemented internally in Warehouse by keeping track of all file changes in internal buffers. If the file is subsequently rolled back, all changes to the file are discarded. If a commit is issued, then all changes are written to disk. These transactional flat files behave like transactional RDBMS files, observing the implied commit rate of a script, or