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

Importing dates from CSV problem

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Importing dates from CSV problem

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • September 16, 2003 at 1:55 pm #14912
      Shadow
      Member

      Based on the file exerpt you had provided, I performed the file import, and I must say, MySql got it in the right way – the date field was preserved exactly as it was… What import did you use, ODBC or CSV and with what options?

    • September 16, 2003 at 2:17 pm #14913
      Bech100
      Member

      I imported using ODBC.

      Where is the CSV option?

      Mark

    • September 16, 2003 at 2:21 pm #14914
      Bech100
      Member

      Ah, just found it, it works that way, but not through ODBC!??!

      Mark

    • September 16, 2003 at 2:23 pm #14915
      Shadow
      Member

      The problem with ODBC is that it tries to figure out the field types and change the values accordingly. Apparently ODBC recognized your “notification date” field – correctly – as date. BTW, you should consider storing that column in a date field because date type corresponds best to that field. In your app you can render the date values as you wish.

    • September 16, 2003 at 2:26 pm #14916
      Shadow
      Member

      Just one more thought: in ODBC text driver you may determine type of the fields. You may want to set “notofication date” to text, but I still suggest you to use date as field type!

    • September 16, 2003 at 2:31 pm #14917
      Bech100
      Member

      Thanks for the info.

      Im not fussy that the date is seen as a date. it is not essential to my application.

      Thanks again

      Mark

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