Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Date Format Calculation

Date Format Calculation 9 months 2 weeks ago #18409

  • pflores
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 1
Visual Importer ETL Enterprise (64 Bit)
Version: 9.2.2.4
Repository Connection type: MS Sql Server

Date records are not inserting into SQL table correctly, please advise on the date calculation. Attached are the examples:

Date format in VI is MM/DD/YY
File format: MMDDYY

When the import is execute, Date column has null values. When I attempt to use other VI date formats, my data for the dates in SQL are jumbled up





Attachments:

Please Log in or Create an account to join the conversation.

Date Format Calculation 9 months 2 weeks ago #18410

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7511
  • Karma: 33
  • Thank you received: 409
Here is the wiki page dedicated to working with date fields

www.etl-tools.com/wiki/vimpe/howto/working_with_date_fields

"Important thing is to understand that this format has nothing to do with your target database.
This is the format of the source data. It is there to help to convert a string into date time type
inside of the software, so it can be loaded later into the date or timestamp field"

You should use MMDDYY format instead of MM/DD/YY
Mike
The following user(s) said Thank You: pflores

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 178 guests and 2 members online