how to insert only date in datetime column of a table

shyam_oec's Avatar, Join Date: Nov 2007
Contributor
Hi, i have a table, with a column having datetime type.But i want to insert only date in that field ,and not time.Is it possible?
If possible how?
Thanks
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Yes but you have to validate that from either front end or from some procedures