> I need a currrent date in SP ...

create procedure myproc
as
declare variable d timestamp;
begin
...
d = 'now'; /* And you receive current date time */
...
end


Agibov Dmitry