Hi,

since @mydate is of type DATETIME you get an implicit conversion of your neatly formatted string back to datetime.

Declare @mydate as a CHAR(14), or what you find suitable, and everything should work as expected...

/Markus