til

Today I Learned: collection of notes, tips and tricks and stuff I learn from day to day working with computers and technology as an open source contributor and product manager

View project on GitHub

See What a Record Looked Like

In Oracle you can retrieve a record in the past, when it has changed:

SELECT * FROM contributors
AS OF TIMESTAMP
TO_TIMESTAMP('1972-01-15 09:30:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE handle = 'jonasbn';

Resources and References

  1. Oracle Docs