declare @myvar datetime
select @myvar = getdate()
exec myproc @myvar
By the way, you should
never start the name of a stored procedure of your own with 'sp_'. SQL Server thinks this means 'system procedure', and looks for it in all schemas in database MASTER before looking in your own database, thus generating needless overhead and degrading performance.
Hope this helps,
Pablo