1
00:00:00,120 --> 00:00:06,450
So we also have a set of these formatting functions that pertain to times and also the time portion

2
00:00:06,450 --> 00:00:07,410
of a date time.

3
00:00:07,410 --> 00:00:11,610
So things like getting the minute or hour from a time.

4
00:00:11,610 --> 00:00:12,690
Let's start with that.

5
00:00:13,080 --> 00:00:21,750
Let's take just the person's name and then their birth time, and then let's get the hour from that

6
00:00:21,750 --> 00:00:22,650
birth time.

7
00:00:23,440 --> 00:00:24,730
From people.

8
00:00:25,320 --> 00:00:27,900
And you'll see we extracted 11.

9
00:00:28,050 --> 00:00:31,250
We got nine 2314.

10
00:00:31,260 --> 00:00:33,570
Nothing all that surprising, probably.

11
00:00:33,660 --> 00:00:35,370
So we also have minute.

12
00:00:36,090 --> 00:00:39,480
The only thing that you have to remember is it's minute and hour and second.

13
00:00:39,480 --> 00:00:41,010
It is not minutes.

14
00:00:41,370 --> 00:00:43,770
It is not seconds or hours.

15
00:00:43,770 --> 00:00:44,760
It is singular.

16
00:00:44,760 --> 00:00:47,250
So let's do seconds so you can see that as well.

17
00:00:47,790 --> 00:00:53,130
So 0 seconds, 10 seconds in this time, zero, 29 seconds in this time.

18
00:00:53,130 --> 00:00:58,350
And these will all work with date time because of course, a date time includes time.

19
00:00:58,920 --> 00:01:05,630
So if I do select, let's just do birth t comma hour from birth d.

20
00:01:05,660 --> 00:01:06,180
T.

21
00:01:06,910 --> 00:01:07,900
From people.

22
00:01:08,410 --> 00:01:11,050
You can see we're getting that hour out of there.

23
00:01:11,080 --> 00:01:17,050
So with date time, we can use all of the date specific formatting functions like day of week, but

24
00:01:17,050 --> 00:01:22,570
also all of the time specific formatting functions like hour and minute and second.

25
00:01:22,780 --> 00:01:28,240
We also can extract the time from a date time or the date from a date time.

26
00:01:28,270 --> 00:01:29,440
If I did this.

27
00:01:29,440 --> 00:01:32,110
So let's, let's look at the whole date time.

28
00:01:32,110 --> 00:01:39,820
But then let's also just look at the date and this will only be the date portion of that birth date

29
00:01:39,820 --> 00:01:40,300
time.

30
00:01:40,300 --> 00:01:45,340
And I have a similar function to get the time out of their birth date time.

31
00:01:45,820 --> 00:01:48,520
It's called time and it gives me the time.

32
00:01:49,260 --> 00:01:51,390
Okay, so that's how we can isolate each portion.

33
00:01:51,390 --> 00:01:54,540
If we only wanted to work with one of those, we can do that.

34
00:01:54,990 --> 00:01:59,300
But I think that's enough detail on these time formatting functions.

35
00:01:59,310 --> 00:02:03,570
There's others that we haven't covered, but for the most part they're pretty self explanatory.