I did following -
create table test_insert_date (field1 datetime not null)
grant all on test_insert_date to public
create proc usp_test_ins_dt
@field1 datetime null
as
select @field1
insert into test_insert_date
values (getdate())
return
After this, I executed the proc as - usp_test_ins_dt getdate()
I got error as "Incorrect syntax near ')'."
But if I run the proc as usp_test_ins_dt "01/01/2008"
It runs fine. Any help in understanding how Sybase is behaving?