mrjimoy_05 mrjimoy_05 - 1 year ago 90
SQL Question

Get Formatted Date in SQL Server CE

How to get the formatted date in SQL Server CE?

I have a column on a table that contains

Date
, but the column type is
nvarchar


ID Date
----------------------
1 05/08/2012
2 10/08/2012
3 05/10/2012


The date format is
MM/dd/yyyy
, but it is in
nvarchar
.

Also, I want to have a
WHERE
clause to select the ID on a specific date. How can I do that? This is for SQL Server CE. Thank you very much.

Answer Source

you need to cover it use convert or cast function ...

cast(datecolumn as DateTime)

or

 CONVERT(datetime,datecolumn,101)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download