Date and time functions

- [Instructor] The date, time, and timestamp…functions are really the easiest ones to learn…because their syntax is so simple.…And these functions will fall into two different categories.…If we go into the Manage Database window,…you see that we have a field called "DateCalc."…That's the field that you see on the layout, here.…We're going to use this as our field…that will allow us to see the results of…our calculation as we experiment with this.…So, first, let's change DateCalc into a…calculation function; say okay and here comes our window.…So, if we select the date functions we'll see that…they really break into two categories.…

One is a group of functions that extract…information about a date or a date field.…So, for example, we can pull the day,…which would be the middle value in a date,…the day name which is Monday, Wednesday,…Tuesday, Thursday, Friday.…Day of week, which is a numerical representation…of Monday through Sunday.…Day of year, a numerical representation…of that day of the year.…You can extract the month, the month name,…