1. Learn
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in SQL Server

Exercise

Selecting parts of the system's date and time

In this exercise, you will retrieve only parts of the system's date and time, focusing on only the date or only the time. You will use the same date and time functions, but you will use CAST() and CONVERT() to transform the results to a different data type.

Instructions 1/2

undefined XP
  • 1

    Use two functions to query the system's local date, without timezone information. Show the dates in different formats.

  • 2

    Use two functions to retrieve the current time, in Universal Time Coordinate.