Original subtitles

0 Next is the age function 1

As I told you 2

One of the important things you will need to do on the date type data 3

Is to find the difference between two dates 4

so age function will return you the number of years months and days between two dates 5

The syntax for age function is age then you specify date 1 which will be the later date 6

that is the newer date 7

Then the date 2 which will be the older date 8

If you do not mentioned date 1 9

Current date will be used as date 1 10

If you want to find out the number of years months and days between these two dates 11

That is how you write it select age mention date 1mention date 2 12

If you remember in our sales table we had shipping date and order date if you want to find out the number 13

of months or days taken between order date and ship date 14

We will write this query where will find out the order line order date ship date and then the age between 15

Ship date and order date 16

Let us go and write these queries 17

so we will select 18

Age 19

Between 20

27 December 2018 21

And 22

say 3rd 23

June 24

2017 25

You run this 26

The difference between these two in one year 6 months and 24 days 27

Next if you want to find out the difference between 28

The number of days taken between order date and ship date let us write select 29

Order line ship date 30

Order date 31

The age between 32

Ship date 33

Which will be the date one 34

And the Order date 35

As 36

The time taken time taken 37

From 38

Sales table 39

Ordered by 40

The time taken 41

let us see 42

descending let us see 43

So 44

These 45

Top orders 46

Have taken 7 days 47

from Order date to ship date 48

If you go down you will find 49

Orders which have taken 50

Six days five days and so on till in the end probably it will be zero days 51

for which you did the shipping on the same day as you got the orders 52

So that's how we find out the 53

Number of days months years between two dates 54

Let us say if you want to extract only day part 55

or month part of the Year part from a date how do we do that 56

For that there is a separate function called Extract function