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

importing datetime from M$ SQL Server 2K

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › importing datetime from M$ SQL Server 2K

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 11, 2003 at 4:30 pm #7682
      Darwin101
      Member

      Hello

      I am using the odbc import in sqlyog 3.0.2, it works well except for importing datetime feilds. All of the mysql datetime fields populate with all 0's. I have tried importing using a CSV file and am having the same problem. Any advice would be greatly appreciated. 😕

      Thanks!

      Nevermind 🙁 I changed the data type to timestamp and it worked… not sure why datetime did not, but thats ok for now

    • February 11, 2003 at 5:41 pm #13713
      Ritesh
      Member

      We are working on how SQL Server keeps datatime data.

      I will post back withing 24 hrs.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.