Select transaction_id and use CAST to convert transaction_date to DATE

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

Select transaction_id and use CAST to convert transaction_date to DATE. Name the result 'txn_date'.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.