time
1.12 KB
You can select/unselect the use of the time field for the transformation by clicking on the check box in the top left corner of the panel (only available during the transformation definition step).
<br/>
<br/>
If the use of the time field is selected, select the time format in the combo box.
<br/>
<br/>
If you select "User defined pattern", enter the pattern on the corresponding text field, by following these rules:
<ul>
<li>all time parts are delimited by brackets '[' and ']' (for example [YYYY])</li>
<li>available time parts are :
<ul>
<li>YYYY : year in 4 digits</li>
<li>YY : two last number of the year, in 2 digits</li>
<li>MM : the month number, in 2 digits</li>
<li>DD : the day of the month, in 2 digits</li>
<li>DOY : the day of the year (1 corresponding to the 1st january), in 3 digits</li>
<li>hh : the hour, in 2 digits</li>
<li>mm : minutes, in 2 digits</li>
<li>ss : seconds, in 2 digits</li>
<li>mls : milliseconds, in 3 digits</li>
</ul>
</li>
<li>separator between two time parts can't be a bracket '[' or ']'
</ul>
For example, a time pattern can be [YYYY]-[MM]-[DD]T[hh]:[mm]:[ss].