Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- convert (datetime, substring(MD_SIGNATURE, charindex('/', MD_SIGNATURE,0)-2, 10),105) as MD_SIGN_DATE
- convert (datetime, substring(MD_SIGNATURE, charindex('/', MD_SIGNATURE,0)-2, LEN(MD_SIGNATURE)),105) as MD_SIGN_DATE
- DECLARE @s varchar(100) = 'Application approved by John Doe - MDat30/01/2018 10:54:31'
- SELECT CONVERT(datetime2(0),RIGHT(@s,19),103)
Add Comment
Please, Sign In to add comment