Skip to content

Instantly share code, notes, and snippets.

@ycaroafonso

ycaroafonso/Convert_DDMMYY_To_DateTime

Last active August 29, 2015 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ycaroafonso/cae52dce321601edc92e to your computer and use it in GitHub Desktop.
Save ycaroafonso/cae52dce321601edc92e to your computer and use it in GitHub Desktop.
Download ZIP
Convert DDMMYY to DateTime
Raw
Convert_DDMMYY_To_DateTime
ALTER FUNCTION dbo.Convert_DDMMYY_To_DateTime (@DiaMesAno INT)
RETURNS DATETIME
AS
BEGIN
-- Ycaro Afonso (2015-04-19)
DECLARE @Data VARCHAR(20) = STUFF(STUFF(@DiaMesAno, 3, 0, '/'), 6, 0, '/')
RETURN CONVERT(DATETIME, @Data, 3)
END
GO
SELECT dbo.Convert_DDMMYY_To_DateTime(190415)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment