SQL CE casting

Hi,

I would like to know if casting is supported in SQL Server Compact Edition. I get an error when i attempt to cast a datetime or bigint value to nvarchar or ntext. CAST(datetime AS nvarchar(15))

Does anybody knows if its supported or how could i cast values

Thank you



Answer this question

SQL CE casting

  • RHPT

    The T-SQL CONVERT function is supported by SQL 2005 Compact Edition, CAST is not available.

    For example: CONVERT(nvarchar(10), OrderDate, 101)



  • SQL CE casting