HomeForum
Welcome, Guest

Adding timestamp to Data import
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Adding timestamp to Data import

Adding timestamp to Data import 1 year, 2 months ago #1799

  • George
  • OFFLINE
  • Junior Boarder
  • Posts: 36
  • Karma: 0
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

Re: Adding timestamp to Data import 1 year, 2 months ago #1800

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
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
ReaderParameters.GIF
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

We had two thousands text files in same format. We were able to load them in one click using Visual Importer ETL.

Pol Barret,
Accountant

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top