When I insert this value 5/22/2007 2:28:04 into a datetime field, the seconds are "missing". Instead of 2:28:04, I end up with 2:28:00 being recorded to the SQL table. Any ideas?
I am inserting the value from an ASP page, so I guess it is an ASP question. The field is datetime and not smalltime. It works in SQL, but not when I insert from an ASP page.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.