All language subtitles for 2. AGE

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