Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LEFT(DATENAME(Day,GETDATE()),3) + '-' +
- LEFT(DATENAME(MONTH,GETDATE()),3) + ' ' + '-' +
- RIGHT('00' + CAST(YEAR(GETDATE()) AS VARCHAR),2)
- SELECT convert(time(0),getDate())
- SELECT LEFT(DATENAME(Day,GETDATE()),3) + '-' +
- LEFT(DATENAME(MONTH,GETDATE()),3) + ' ' + '-' +
- RIGHT('00' + CAST(YEAR(GETDATE()) AS VARCHAR),2) + ' '
- convert(time(0),getDate())
- SELECT LEFT(DATENAME(Day,GETDATE()),3) + '-' +
- LEFT(DATENAME(MONTH,GETDATE()),3) + ' ' + '-' +
- RIGHT('00' + CAST(YEAR(GETDATE()) AS VARCHAR),2) + ' ' +
- cast(convert(time(0),getDate()) as varchar(10))
Add Comment
Please, Sign In to add comment