Far from perfect but this should work -

select cast(convert(varchar,getdate(),103) as datetime)

Regards

Jon

>I'd like to set the default value for a smalldatetime field as Getdate(), but with zeros in the HH:MM:SS:MS part.
>
>How to do?
>
>TIA & BR