I am pretty new to DB2 RDMS, but I have lots of experience inside the SQL Server world.
The other day I created a native SQL store procedure inside Toad for our DB2 server. I am running into an odd issue and was wondering if anyone else has had this issue.
Two of my parameters is are timestamp types. I need to grab the date and time for a given a range such as 2014-04-30 17.00.09 to 2014-05-01 17.00.09.
I have noticed in toad when executing a sql store procedure timestamp parameters will only allow you to enter the date and not the time part.
Has anyone else had this issue before? My store procedure will execute fine in SSRS and Advanced Query Language.
Toad Version: 220.127.116.110
Thank you for your time.