Datastage Parallel Job Functions.doc

增加函数格式说明DateToString，DecimalToDecimal<br><br><br>Format String<br>Date, Time, and Timestamp functions that take a format string (e.g. timetostring(time, stringformat)) need specific formats.<br>For a date, the format components are:<br>• %dd two digit day<br>• %mm two digit month<br>• %yy two digit year (from 1900)<br>• %year_cutoffyy two digit year from year_cutoff (e.g. %2000yy)<br>• %yyyy four digit year<br>• %ddd three digit day of the year<br>The default format is %yyyy-%mm-%dd<br>For a time, the format components are:<br>• %hh two digit hour<br>• %nn two digit minutes<br>• %ss two digit seconds<br>The default is %hh:%nn:%ss, or, if extended to include microseconds, %hh:%nn:%ss.x where x gives the number of decimal places seconds is given to.<br>A timestamp can include the components for date and time above. The default format is %yyyy-%mm-%dd %hh:%nn:%ss, or, if extended to include microseconds, %yyyy-%mm-%dd %hh:%nn:%ss.x where x gives the number of decimal places seconds is given to<br>