That simple, :-) huh?
Thank's.
>>I'd like to set the default value for a smalldatetime field as Getdate(), but with zeros in the HH:MM:SS:MS part.
>>
>
DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)