Oracle TO_TIMESTAMP Function

Published: 05 February 2017
on channel: Database Star
6,269
25

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...

The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video.

This function allows you to convert a string value into a TIMESTAMP value.

A TIMESTAMP value is a type of DATE, but has a few components:
A date, including day, month, and year
A time, including hours, minutes, seconds, and fractional seconds