[Solved] Return Order Date Format Differently January 4, 2023 by Kirat Use this: CONVERT(VARCHAR(10),OrderDate,10) as OrderDate Taken from the very first search result. solved Return Order Date Format Differently