المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Convert COleDateTime to SQL datetime column type



C++ Programming
10-10-2010, 02:01 AM
COleDateTime date = COleDateTime::GetCurrentTime();
CString one_id = "A001";
CString description = "test";


sqlSP.Format("declare @data_uid as integer exec dbo.msp_Insert %s, %s, %d, @doc_uid output select @doc_uid AS doc_uid",
one_id,
description,
date

);


i need to insert a COleDateTime in MFC to a MS SQL table, with column as datetime.
Can anybody tell me what is the error???

I guess there is a CString formatting error...


Any help will be great.

Saleem