SELECT CONVERT(VARCHAR(11), GETDATE(), 106) +' ' + RIGHT(CONVERT(VARCHAR(25), GETDATE(), 22),11) [Date] --26 Sep 2013 2:17:24 PM SELECT Replace(CONVERT(VARCHAR(11), GETDATE(), 106),' ','/') + ' ' +RIGHT(CONVERT(VARCHAR(25), GETDATE(), 22),11) [Date] --26/Sep/2013 2:17:24 PM
DECLARE @d datetime = getdate() SELECT convert(VARCHAR(11),@d,6) + ' ' + substring(convert(varchar(30), @d, 9), 13, 8) + ' ' + right(convert(varchar(30), @d, 9), 2);
DECLARE @lng INT DECLARE @cut INT SET @lng = LEN(CONVERT(VARCHAR(30),GETDATE(),113)) SET @cut = CHARINDEX(':', REVERSE(CONVERT(VARCHAR(30),GETDATE(),113))) SET @lng = @lng - @cut SELECT LEFT(CONVERT(VARCHAR(30),GETDATE(),113),@lng) AS Date, @lng AS LNG
DECLARE @dt DATETIME SET @dt = CONVERT(datetime,GetDate(),101)
SELECT CONVERT(DATETIME, CONVERT(VARCHAR(19), GETDATE(), 120))
SELECT CONVERT(VARCHAR, GETDATE(), 103) SELECT CONVERT(VARCHAR, GETDATE(), 104) SELECT CONVERT(VARCHAR, GETDATE(), 105) SELECT CONVERT(VARCHAR, GETDATE(), 106)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)