to get a only date from date time picker...

[jaimin4829]

we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database.
using we want only date...

& xyzdtp.value.date &

[M.Waqas Aslam]

you can do like this

datetimepicker.value.date.tostring()
'or you can set format property according to your requirement .

Regards

[M.Waqas Aslam]

and if you have datatype datetime in your db , then auto time will be added in your records , this will not effect any thing , and you can perform any task.

Regads

[jaimin4829]

and if you have datatype datetime in your db , then auto time will be added in your records , this will not effect any thing , and you can perform any task.

Regads

'ya in mssql2005 datatype is datetime so...but it affect while comparing....
'also using formate property it enter time in database..

[M.Waqas Aslam]

no it will not effect your result can you please write your query here , so that i can better ans you.