DATE Data Type - Oracle to MariaDB Migration

In Oracle, the DATE data type stores date and time data (year, month, day, hour, minutes and seconds). In MariaDB Oracle compatibility mode, you can also use the DATE data type.

Oracle:

  -- Sample table  
  CREATE TABLE specs
  (
    cnt1 DATE
  );

MariaDB - Oracle Compatibility:

   -- Sample table  
  CREATE TABLE specs
  (
    cnt1 DATE
  );

If you run SHOW CREATE TABLE for the table above, you can see how MariaDB represents this table internally:

MariaDB - Oracle Compatibility:

  CREATE TABLE "specs" (
  "cnt1" datetime DEFAULT NULL
  )

Note that Oracle DATE data type is represented as the native DATETIME data type.

For more information, see Oracle to MariaDB Migration - Oracle Compatibility Mode.