Hi SELECT DISTINCT CAST(MRNDate AS DATE) FROM TRNS_MRN How to add column name MRNDate as Datetime datatype