How do I change the date format in a SQL Select query?
How do I change the date format in a SQL Select query? How to get different date formats in SQL ServerUse the SELECT statement with CONVERT function and date format option for the date values needed.To get YYYY-MM-DD use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 23)To get MM/DD/YY use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 1) How can get date in dd mm yyyy format in MySQL? MySQL uses yyyy-mm-dd format for storing a date value. This format is fixed and it is not possible to change it. For example, you may prefer to use mm-dd-yyyy format but you can't....