Seconds missing when insert datetime

[christer99]

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?

 

[gmmastros]

Are you sure it's a DateTime column. There is also a SmallDateTime that has a resolution to the minute.

Declare @Temp SmallDateTime
Set @Temp = GetDate()

Select @Temp, GetDate()

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[RobertT687]

Note also that SmallDateTime will Round Up. Any Datetime more than 30 seconds past a given minute rounds up to the next minute.

 

[christer99]

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.