- Posts: 51
- Thank you received: 0
Adding timestamp to Data import
12 years 7 months ago - 12 years 7 months ago #1799
by George
Adding timestamp to Data import was created by George
Can a timestamp be added by the import tool and stored with all records as an extra field into MySQL table?
This timestamp may either be sysdate or file creation date?
can both of these options be supported?
George
This timestamp may either be sysdate or file creation date?
can both of these options be supported?
George
Last edit: 12 years 7 months ago by George.
Please Log in or Create an account to join the conversation.
12 years 7 months ago #1800
by admin
Mike
ETL Architect
Replied by admin on topic Re: Adding timestamp to Data import
You can use current data function to get a timestamp
or you can use reader parameter to get file creation data
See attached picture.
Mike
or you can use reader parameter to get file creation data
See attached picture.
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.