convert(varchar(8), getdate(), 112);orconvert(varchar, getdate(), 112)
Source: sql server – Convert a date to yyyymmdd format – Database Administrators Stack Exchange
Recent Posts
Recent Comments
- fkim on microsoft/mssql-server-linux – Docker Hub
- fkim on microsoft/mssql-server-linux – Docker Hub
- fkim on LadyNaggaga/ASP.NETCoreMVA: Microsoft Virtual Academy MVA
- fkim on ASP.NET Core MVC app running on Raspberry Pi – Laurent Kempé
- fkim on Running a .NET Core 2 app on Raspbian Jessie, and deploying to the Pi with Cake | Jeremy Lindsay
Archives
Categories
- .Net Core
- Android Studio
- Cross Platform Development
- Docker
- Git
- Google Map
- IBM Technology
- Idea
- Information Technology
- IOT
- Java Script Library
- Kodi
- MAXIMO
- Office Tips
- PHP
- PowerApp
- Powershell
- RaspberryPi
- SamSung Tizen
- SharePoint
- Ubuntu
- Uncategorized
- Video Editor
- Visual Code
- Visual Studio
- Web Developer's Tool
- Windows SDK
- WordPress / PHP / MySql
- Writing