Tracnac/Table Timestamp.md

Last active September 23, 2022 17:07

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Tracnac/fd0b33066991d2c0e9e6934ed162d76c.js"></script>
Save Tracnac/fd0b33066991d2c0e9e6934ed162d76c to your computer and use it in GitHub Desktop.

Download ZIP

Table Timestamp #oracle

Raw

Table Timestamp.md

CREATE TABLE mytablesave
AS
    SELECT *
    FROM (SELECT *
    FROM mytable
    AS OF TIMESTAMP TO_DATE ('14/11/2011 17:00:00', 'DD/MM/YYYY HH24:MI:SS'));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment