Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date/Time not displaying seconds
I had this very problem in my Microsoft Access database (connecting to SQL 2000 data) and found that the data field in my table was created as a smalldatetime field. When I changed it to a datetime field it saved the seconds properly.
