So we also have a set of these formatting functions that pertain to times and also the time portion
of a date time.
So things like getting the minute or hour from a time.
Let's start with that.
Let's take just the person's name and then their birth time, and then let's get the hour from that
birth time.
From people.
And you'll see we extracted 11.
We got nine 2314.
Nothing all that surprising, probably.
So we also have minute.
The only thing that you have to remember is it's minute and hour and second.
It is not minutes.
It is not seconds or hours.
It is singular.
So let's do seconds so you can see that as well.
So 0 seconds, 10 seconds in this time, zero, 29 seconds in this time.
And these will all work with date time because of course, a date time includes time.
So if I do select, let's just do birth t comma hour from birth d.
T.
From people.
You can see we're getting that hour out of there.
So with date time, we can use all of the date specific formatting functions like day of week, but
also all of the time specific formatting functions like hour and minute and second.
We also can extract the time from a date time or the date from a date time.
If I did this.
So let's, let's look at the whole date time.
But then let's also just look at the date and this will only be the date portion of that birth date
time.
And I have a similar function to get the time out of their birth date time.
It's called time and it gives me the time.
Okay, so that's how we can isolate each portion.
If we only wanted to work with one of those, we can do that.
But I think that's enough detail on these time formatting functions.
There's others that we haven't covered, but for the most part they're pretty self explanatory.