From the course: SQL for Healthcare Professionals

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Date manipulation in SQL

Date manipulation in SQL - SQL Tutorial

From the course: SQL for Healthcare Professionals

Start my 1-month free trial Buy for my team

Date manipulation in SQL

“

- [Instructor] Healthcare analysts use dates quite frequently. Measurements such as tracking dates of patient encounters, monitoring treatment progress and analyzing trends over time relies heavily on data manipulation. SQL has data functions that offer simple approach to working with date and time data effectively. Let's look into different SQL functions and how to use each of them. First, let's look into the function, get date. This function enables the SQL user to retrieve and make calculations using the current date and time from the system. You can type, select, get date, and let's name this column, "Today." If you highlight and run this query, this will give you the current date and time when you're running this command. The next function is called date part. This function enable the SQL user to extract integer values, represent specific parts of a date or time, such as year, month, hour, minute, and so on.…

Contents