Description\n-----------\n\nBitemporal tables are tables that use versioning both at the system and application-time period levels.\n\nUsing Bitemporal Tables\n\nTo create a bitemporal table, use:\n\n``sql\nCREATE TABLE test.t3 (\n   date_1 DATE,\n   date_2 DATE,\n   row_start TIMESTAMP(6) AS ROW START INVISIBLE,\n   row_end TIMESTAMP(6) AS ROW END INVISIBLE,\n   PERIOD FOR application_time(date_1, date_2),\n   PERIOD FOR system_time(row_start, row_end))\nWITH SYSTEM VERSIONING;\n`\n\nNote that, while system_time here is also a time period, it cannot be used in DELETE FOR PORTION or UPDATE FOR PORTION statements:\n\n`sql\nDELETE FROM test.t3 \nFOR PORTION OF system_time \n    FROM '2000-01-01' TO '2018-01-01';\nERROR 42000: You have an error in your SQL syntax; check the manual that corresponds \n  to your MariaDB server version for the right syntax to use near\n  'of system_time from '2000-01-01' to '2018-01-01'' at line 1\n``\n\nURL: https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/bitemporal-tables