Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   how to insert only date in datetime column of a table (http://www.go4expert.com/forums/insert-date-datetime-column-table-t21563/)

shyam_oec 29Mar2010 13:51

how to insert only date in datetime column of a table
 
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 29Mar2010 15:07

Re: how to insert only date in datetime column of a table
 
Yes but you have to validate that from either front end or from some procedures


All times are GMT +5.5. The time now is 07:29.