Hello guys i have a date format of 12/05/2015 i.e., dd/mm/yyyy . I need to convert this as 05/12/2015 i.e., mm/dd/yyyy . Can any one give me a solution .
标签:
informatica
相关问题
- Can ETL informatica Big Data edition (not the clou
- INFORMATICA - Date format conversion
- PowerCenter REG_EXTRACT issue
- How to get max of a column in informatica?
- Reprocess tabular cubes after failure using Inform
相关文章
- 的PowerCenter REG_EXTRACT问题(PowerCenter REG_EXTRACT
- 的Informatica - CONCATENATE 1列的所有行的单个值(Informatic
- 对Informatica的的PowerCenter SQL Server存储库(SQL Server
- Informatica的的PowerCenter VS定制的Perl ETL作业?(informat
- 快照太旧错误(Snapshot too old error)
- INFORMATICA - Date format conversion
- PowerCenter REG_EXTRACT issue
- How to get max of a column in informatica?
Use the below command, this will give you the value as per you requirement
Because function TO_DATE by default expects the date as a char value to be in the form 'MM/DD/YYYY', you need to specify you're handing it in as 'DD/MM/YYYY'. Then you want the final output to be a string (presumably) in format 'MM/DD/YYYY', so for that you need the function TO_CHAR. So you have to jump that hurdle, too. The final statement for your example, then, looks like this:
The output will be '05/12/2015'.
Use the function TO_DATE
It will work.
In informatica Help file, There is a chapter called "functions". In that check TO_DATE function.
TO_DATE( string [, format] )
String ---- Must be a string datatype. Passes the values that you want to convert to dates. You can enter any valid transformation expression.
format ---- Enter a valid TO_DATE format string. The format string must match the parts of the string argument. For example, if you pass the string '20150515', you must use the format string 'YYYYMMDD'.