@ Jggtz and FunkyDexter
I updated my Question, Post # 1.


I didn't use any such converting in my code. So does it mean that SQL Server does this automatically?