Timestamp parametr

Database
Enthusiast

Timestamp parametr

I have procedure with 2 parameters

 

create Intro_procedure( id ineteger, date_id timestamp(3))

begin

...

end;

 

But, i don't know how to call this procedure???

 

like this:  call Intro_procedure(5, '2015-06-05')    ????? - it's not work!

 

PLs help!

2 REPLIES
Junior Contributor

Re: Timestamp parametr

'2015-06-05' is not a Timestamp, it's a Date.

 

Either write a date literal DATE '2015-06-05' or add the time portiton '2015-06-05 00:00:00' (or better TIMESTAMP '2015-06-05 00:00:00').

Or simply switch to a date parameter if you don't care about the time. 

Enthusiast

Re: Timestamp parametr

tnx a lot  - it's works!