SPL question
- From: "Colin Dawson" <cjd_1955@xxxxxxxxxxx>
- Date: Tue, 18 Oct 2005 09:04:21 +0000
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
.
- Follow-Ups:
- Re: SPL question
- From: Richard Harnden
- Re: SPL question
- Prev by Date: Re: Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
- Next by Date: RE: Shared Memory not Initialized for INFORMIXSERVER on
- Previous by thread: Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
- Next by thread: Re: SPL question
- Index(es):
Relevant Pages
|
