Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

date format in sql

SELECT CONVERT(VARCHAR, GETDATE(),101) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),102) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),103) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),104) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),105) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),106) AS DATE

SELECT DATE = FORMAT(GETDATE(), 'dd-MM-yyyy')
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #date #format #sql
ADD COMMENT
Topic
Name
1+1 =