1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server

Exercise

Format for Germany

Write a query to display the TotalDistance, TotalRideTime and TotalFare for each day and NYC Borough. Display the date, distance, ride time, and fare totals for German culture.

Instructions

100 XP
  • Cast PickupDate as a date and display it as a German date.
  • Display TotalDistance and TotalRideTime in the German format ('n' format type parameter).
  • Display Total Fare as German currency ('c' format type parameter).