From the course: Oracle Database 19c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Datetime functions

Datetime functions

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial

Datetime functions

“

- [Narrator] Database single row built in functions can be divided into several categories, character, number, date, conversion and the catch all general. I'll give a detailed overview of the date related built in functions and how they are used in the select statement or any SQL statement. Also I'll be talking a bit about date columns versus timestamp columns. To see how datetime functions fit in with the rest, here's an overview of single row functions. They fall into five basic categories, character, numeric, date and arithmetic, conversion and general. Some of the conversion functions and general functions may technically fall into the number functions only because they return a number, but we'll cover them in a different lesson. A few of the datetime functions are specifically for date columns, but most also operate with the longer and more feature rich timestamp columns. I'll go over a few of these in this lesson. A really big distinction with datetime columns is whether the…

Contents