Member Avatar for xXxWiredxXx
xXxWiredxXx 0 Newbie Poster

im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql..
i have this sql statement on my MsAccess

SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt
FROM WItems INNER JOIN MI ON WItems.WIStockNo=MI.WIStockNo;

then.. i got error's on this one >>>

Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period

Truncated incorrect INTEGER value: ', '

the result supposed to be this one >> 02, 2009
but it turn to 0...
help pls.. thanks

  • 1 Contributor
  • 0 Replies
  • 72 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.