The simplest way today is:

SELECT 
    CAST(OrderDate AS DATE) AS OrderDateOnly, -- Extracts the date part
    CAST(OrderDate AS TIME) AS OrderTimeOnly  -- Extracts the time part
FROM 
    Orders;