teoriskai sitas cast(floor(cast(getdate() as float)) as datetime) turetu 
buti greiciausias, nes ner darbo su stringais

"Jornada Del Muerto" <agira@TRINTIgmx.co.uk> wrote in message 
news:i40pqj$9tu$1@trimpas.omnitel.net...
> dar 1 draugas, ex kolega pasiule:
>
>    select DateAdd(dd, 0, DateDiff(dd, 0, getdate()))
>
> Velnias reik imti visus siuos metodus ir ziuret kuris greiciausias :)
>
> "Dream-Colored Bunny" <cream@lemon.nospam> wrote in message 
> news:i40pje$9jo$1@trimpas.omnitel.net...
>>> cast(floor(cast(getdate() as float)) as datetime)
>>
>> Ash va taip ir darau.