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

*** Sent via Developersdex http://www.developersdex.com ***

[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

"Joey Martin" <jo**@infosmiths.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***