Categories
SQL SQL Server

SQL: YYYYMMDD

SELECT CONVERT(VARCHAR(8), GETDATE()-365, 112)

This is a way to query and get the date in the following format:

YYYYMMDD

I came across some dates saved in the database in this format as a varchar and had to use this to initially get the date and then convert it from and integer to varchar.

Related posts:

  1. Convert Julian Dates in SQL SERVER SQL SERVER JULIAN TO DATE (WHEN DOWNLOADING JULIAN DATE) date...
  2. Convert from varchar to decimal Here’s a way to convert a VARCHAR to DECIMAL, wrap...
  3. .NET ToString Format Specifiers Standard Numeric Format Specifiers (C) Currency: . . . ....
  4. Insert data from one table to another table INSERT INTO "table1" ("column1", "column2", ...) SELECT "column3", "column4", ......