SPL question
Posted in 2005
Colin Dawson — — source: Usenet: comp.databases.informix
I have an SP that takes a relative day and a time as input e.g. ('-7','16:30:45') and am using the following code to set a variable to a datetime string let p_cr_date = EXTEND(p_cr_day + p_add_days UNITS DAY, YEAR TO SECOND)+INTERVAL(p_cr_time) HOUR TO SECOND; This would expand to:- EXTEND(TODAY-7 UNITS DAY,YEAR TO SECOND)+INTERVAL(16:30:45) HOUR TO SECOND If I exclude the INTERVAL part of the code it all works but if I include it I get a syntax error. My question is, can I do this (or something similar) in SPL? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't sending to informix-list