Convert nvarchar to smalldatetime

[Joey Martin]

How do I convert an nvarchar field to smalldatetime format?

My nvarcharfield (saledatetext) is in the format YYYY-MM-DD.

I want to convert is to smalldatetime (field: saledate)

Thanks for the help

 

[Mark J. McGinty]

CONVERT(DATETIME, saledatetext, 120)

Note that the third parameter (which indicates date format) is not strictly
necessary when using yyyy-mm-dd, but it is when using formats that can be
ambiguous.


-Mark