Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Import External Data Tool Uses Timestamp Instead Of Datetime

forums › forums › SQLyog › Using SQLyog › Import External Data Tool Uses Timestamp Instead Of Datetime

Tagged: , , ,

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 8, 2013 at 6:32 am #34157
      sathish
      Member

      Hello,

      What you can do here is create a job file by selecting the required tables from Import External Data Wizard. You can edit the job file and replace timestamp with datetime and run the job file. This will solve your problem.

      Regards,

      Sathish

    • February 12, 2013 at 8:11 pm #34158
      kipthegreat
      Member

      That solved it. Thanks!

    • February 13, 2013 at 4:42 am #34159
      peterlaursen
      Participant

      Additinally it is not possible to distinguish a TIMESTAMP and DATETIME when using ODBC, as ODBC has only one data type for both. We map to TIMESTAMP as default (because we need to choose one of them), but user may need to remap.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.