I am doing an up date statement like the following:
table.dateupdated is nvarchar(255) so when the update happens it's converting the datetime to style 109.
Here's a test:
How do I get the style to stay at 120 with in the nvarchar datatype??Thanks! K
To get a style in the nvarchar, you need to specify it when converting to the nvarchar, so:
in fact the inner convert to 120, is un-needed
both give2011-09-16 00:00:00