You are tasked with creating a table to store order data, including a timestamp for when the order was placed. However, the finance team prefers to query this data in date format. To accommodate this, you decide to add a calculated column that converts the orderTime timestamp to a date. Complete the DDL statement to achieve this.

CREATE TABLE orders ( orderId int, orderTime timestamp, orderdate date _____________________________________________ , units int)