Converint int Date to SQL datetime? RRS feed

  • Question

  • User1892900632 posted

    Hopefully this is the right forum, but I've searched the web and can't find a solution that works.  I have a table adapter in my VS2010 project where I'm doing a select statement from a MySQL server where the date is stored as a INT.  My select works based off the date that is passed to it so it only select items from a certain date range.

    Well I can't figure out how to convert the MySQL date to a datetime to compare it to the date input.

    I've tried convert() within the select statment but keep getting errors.

    Monday, September 17, 2012 3:29 PM


All replies