Tuesday, September 26, 2017

Comparing Oracle and N1QL Support for the Date-Time Feature (Part 1)

DZone Database Zone
Comparing Oracle and N1QL Support for the Date-Time Feature (Part 1)
Comparing Oracle and N1QL Support for the Date-Time Feature (Part 1)

Date and time formats/types are very different for different databases. In this article, we will compare Couchbase N1QL date-time functions with Oracle's date-time support.

Oracle contains multiple data types associated with date-time support — namely DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. The TIMESTAMP data type is an extension of the DATE type.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...