SQL Server date format yyyymmdd

Question

I have a varchar column where some values are in mm dd yyyy format and some are in yyyymmdd    I want to convert all mm dd yyyy dates into the yyyymmdd format  What is the best way to do this  Thanks  Table is Employees and column is DOB

User · Answer

You can do as follows  Select Format test Time   yyyyMMdd   From TableTest test

User · Answer

In SQL Server  you can do   select coalesce format try convert date  col  112    yyyyMMdd    col    This attempts the conversion  keeping the previous value if available   Note   I hope you learned a lesson about storing dates as dates and not strings

User · Answer

Select CONVERT VARCHAR 8   GETDATE    112    Tested in SQL Server 2012  https   www w3schools com sql func sqlserver convert asp

User · Answer

Assuming your  date  column is not actually a date   Select convert varchar 8  cast  12 24 2016  as date  112    or   Select format cast  12 24 2016  as date   yyyyMMdd     Returns  20161224

User · Answer

SELECT  YEAR getdate      10000   MONTH getdate      100   DAY getdate

User · Answer

SELECT TO CHAR created at   YYYY-MM-DD   FROM table    converts any date format to YYYY-MM-DD

User · Answer

try this      SELECT FORMAT CAST DOB AS DATE   yyyyMMdd   FROM Employees

User · Answer

DECLARE  v DATE   3 15 2013   SELECT CONVERT VARCHAR 10    v  112    you can convert any date format or date time format to YYYYMMDD with no delimiters

[sql-server] SQL Server date format yyyymmdd

Examples related to sql-server

Examples related to database

Examples related to date

Examples related to datetime

Examples related to varchar