Community Member Profile
James Knowlton
Member since Dec 11, 2008
- Profile: /members/686-James-Knowlton.htm
- Comments: 1
- Points: 1
Recent Blog Comments By James Knowlton
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jan 4, 2007 at 5:14 PM
I also run into the date/time problem on SQL Server. I have solved the problem in several ways. When possible I simply create the table column with a check statement that prevents time from being added: create table test ( dateonly datetime null constraint ckc_dateonly check (D... read more »
