Use any acceptable format for INTERVAL values inside a CSV or XML file.
The following are acceptable formats for INTERVAL values:
a 64-bit signed integer representing a number of microseconds.
[D [day[s]]][ ][HH:MI[:SS[.FF]]] (for example, 1 02:03:04.000005).
[D day[s]][ ][HH hour[s]][ ][MI minute[s]][ ][SS[.FF] second[s]] (for example, 1 day 2 hours 3 minutes 4.000005 seconds).
For a complete list of valid formats for INTERVAL values, see 'INTERVAL Literals" in the Sybase CEP CCL Reference Guide .
Although CCL statements require the keyword INTERVAL prior to the value for some of these forms, no INTERVAL keyword is required when using such values in CSV or XML files.