Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to convert int to nchar(3) in sqlce 3.5

Author  Topic 

sayer
Starting Member

35 Posts

Posted - 2013-03-05 : 07:52:13
Hello every body

I use sqlce 3.5

i want convert integer column in select statement

code

SELECT id, type_task,date_year ,cast(date_month AS nchar(3)) , date_day, state, note
FROM task_tb AS task_tb_1
WHERE (id =1)


error

Data conversion failed. [ OLE DB status value (if known) = 2 ]

please help me.............

http://aman-services.net
for office
???? ???? ???????

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2013-03-05 : 11:45:28
do you mean you're using SQL server compact edition?

If so provide sample data for the projecting columns

id, type_task,date_year ,date_month, date_day, state, note

And what is the datatype for Date_Month field in your table?

Cheers
MIK
Go to Top of Page
   

- Advertisement -