Posted by Plamen Ratchev on 01/21/08 22:39

The SMALLDATETIME data type in SQL Server is with precision to the minute,
so this is why you see the seconds trimmed off. If you want to store seconds
then you have to alter your table and change the column to DATETIME data
type.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Access 2000 and SQL Server 2005
• Prev in forum: Re: Access 2000 and SQL Server 2005
• Thread view: Re: Timestamp Precision

[Reply to this message]