Nice question and i learned about accuracy and 2012 function(DATETIMEFROMPARTS). I don't know how this accuracy will help me in production..

What I feel is Instead of assigining values to all variables in seperate select statement,Either could have done it in single select or as shokx said straight away could written in one statement..