文件名称：Datastage Parallel Job Functions.doc
文件大小：202KB
文件格式：DOC
更新时间：2011-08-13 16:35:37
DataStage函数说明
增加函数格式说明DateToString，DecimalToDecimal
Format String
Date, Time, and Timestamp functions that take a format string (e.g. timetostring(time, stringformat)) need specific formats.
For a date, the format components are:
• %dd two digit day
• %mm two digit month
• %yy two digit year (from 1900)
• %year_cutoffyy two digit year from year_cutoff (e.g. %2000yy)
• %yyyy four digit year
• %ddd three digit day of the year
The default format is %yyyy-%mm-%dd
For a time, the format components are:
• %hh two digit hour
• %nn two digit minutes
• %ss two digit seconds
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.
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