How to get the formatted date in SQL Server CE?
I have a column on a table that contains
Date
nvarchar
ID Date
----------------------
1 05/08/2012
2 10/08/2012
3 05/10/2012
MM/dd/yyyy
nvarchar
WHERE
you need to cover it use convert or cast function ...
cast(datecolumn as DateTime)
or
CONVERT(datetime,datecolumn,101)