extract

Filtering on Date Values using the SQL WHERE Clause (Introduction to Oracle SQL)

0:00
↔️ ↕️

Timecodes:

filtering on date values so far we've

just filtered on text and number values

what if you want to filter on dates

filtering on dates is a little different

but I'll show you how easy it can be to

filter on a date value you can do it in

two ways you can enter it inside single

quotes in the default format of your

database or you can use a function we'll

explain how to use a function in a later

lesson but for now let's take a look at

a filter on date values in this lesson

we're going to filter this data on a

date value let's see what data we have

in our employees table we can see our

data here now let's say we want to

filter on the higher data column we only

want to show records where the employee

hire date is equal to 3rd of October

2010 in our query we're putting the word

where and then higher underscore date


Related queries:


how to extract date from timestamp in sql server
how to extract date from timestamp in sql oracle
how to get date from timestamp in sql
how to remove date from timestamp in sql
how to retrieve date from timestamp in sql
how to get date from timestamp in sql developer
how to get date from timestamp in sql db2
how to get datetime from timestamp in sql server
how to extract only date from timestamp in sql