From the course: Microsoft SQL Server 2016: Query Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Queries using date and time - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Queries using date and time
- [Instructor] In this lesson we're going to take a look at working with date time values in our SQL Server database. We'll see an example of how we can query the date values by using different query aspects and then we'll also take a look at some of the functions that we can use within SQL Server for manipulating and or looking at date time values. So again, these are built-in functions that you'll find in SQL Server. First, let's go ahead and run a query against our Employee table to see how the dates are stored in the HireDate field within that table. So we highlight that first query, and if we run it we'll see that the HireDate is actually stored with the year first, the month second, and the day last. Depending on your locale and sometimes depending on how you set up your collation settings when you do the installation of SQL Server your date format display may be different than what you're seeing on my screen. So a lot of this is really determined on your localization settings…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.