Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
FORMAT FUNCTION (New Feature of 2012 sql server)
SELECT FORMAT(GETDATE(), 'yyyy-MM-dd') AS [ISO Formatted Date], FORMAT(GETDATE(), 'yyyy-MM-dd hh:mm:ss') AS [Full ISO], FORMAT(GETDATE(), 'MMMM dd, yyyy') AS [Long-EN Date], FORMAT(22.7, 'C', 'en-US') AS [US Currency], FORMAT(22.7, 'C', 'ta-IN') AS [INDIA Currency], FORMAT(99 * 2.226, '000.000') AS [Padded Decimal], FORMAT(12345678, '0,0') AS [Commas in Large Numbers]
run
|
edit
|
history
|
help
0
All the k-mers/n-grams
Employye
a
b
Basic Template
aa
SQL Server - NULL values with IN and NOT IN (Solution)
exp7
QLSV
SQL_Joins_RankingFunctions