Why would you use cast over convert?

[RiddleMeThis]

When and why would you ever use 'cast' over 'convert'?

I presume there is a slight difference in speed as cast doesn't do quite as much as convert, but surely the difference would be so small that it is insignificant.

Would you only use cast to make scripts more portable for other SQL environments like Oracle, or does cast have a technical advantage over convert in some situation that im unaware of?

 

[Crowley16]

generally, I only ever use convert if I actually need the result to be formatted in a particular way and the datatype is datetime... the main reason being, cast is quicker to type and has less arguments...

--------------------
Procrastinate Now!