cast function

[b00gieman]

Hi!

Is it possible to update the content of a column from a table(smalldatetime) with nvarchar data using CAST? The nvarchar string is mm/dd/yyyy and so is the date format

 

[Glasgow]

Don't see why not! Something like:

SET DATEFORMAT MDY
UPDATE MyTable SET DateField = CAST(VarCharField AS datetime)

SQL should treat the slashes as a valid date delimiter and the SET DATEFORMAT will ensure correct interpretation of US date format.

 

[b00gieman]

thanks!