UniVerse does not have a timestamp data type. This is at the heart of your problem.
Find some Microsoft documentation that mentions that MS Query now generates a timestamp instead of the date it used to generate, and bleat long and loud to Microsoft about it. Meanwhile, since that will be ignored, you need to find some kind of workaround, either to generate just a date, or to have UniVerse recognize the timestamp and extract just the date portion thereof. > ----- Original Message ----- > From: "Sunny Matharoo" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: [U2] UV ODBC Oddity > Date: Fri, 1 Feb 2008 14:06:27 -0000 > > > Hi > > > > We was wondering if anyone could help, we have users that have old > queries that they have run in MS Query before with no problem using IBM > ODBC query drivers. > > > > What we are having now is when they open a query it reports an error > around "TS" and when you look at the sql statement, rather than passing > a date it is now passing a date and time, now obviously UV does not seem > to be able to handle this. > > > > Any ideas would be great > > > > We have UV 10.2.4 on AIX 5.2 > > > > Thanks > > > > Sunny > > Sunny Matharoo > Applications and Database Administrator > > Tristar Worldwide Chauffeur Services > Tel: +44 (0) 1895 432072 > Fax: +44 (0) 1895 432098 > Mobile: +44 (0) 7793 184144 > Email: [EMAIL PROTECTED] > www.tristarworldwide.com > <BLOCKED::blocked::http://www.tristarworldwide.com/> > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
