>I have a report with "Date" not "DateTime" parameter.
>
>I need to call it from Sql-Server store procedure. How can I convert DateTime into Time?
>
>In VFP "Dtot(Date())" works well
>
>In Sql-Server i used "Cast(Cast(GetDate() As Int) As DateTime)" but it doesn't work.
>
>TIA
you have use
"select cast(Cast(GetDate() As VarChar) as datetime)"