10-30-2014 04:01 AM
I may have lost my mind at the moment so any quick idea would help certainly....
So I have variable which is in the TIME13.3 format whereas I have another variable which is in numeric format ....Now I need to put a WHERE clause however before that need to convert TIME13.3 format variable to the numeric format I tried PUT function however that doesn't seems to work...quick thought please?
10-30-2014 06:13 AM
TIME13.3 is a numeric format, so your variable is already numeric (seconds of the day) and can be "converted" by simply changing its format.
I suspect that yoout other variable has a specific sequence of digits; could you give an example?
10-31-2014 02:57 AM
Thanks Kurt you was correct i put the TIMEPART(VAR2) and it resolved the problem...thanks for pointing in right direction..