Hi You may want to check out the convert function in SQL Server. You can issue these in your SQL statements that you pass to SQL Server. The cast function may also be of use. You can get more info from Books Online (BOL) for SQL Server. Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspxBooks Online for SQL Server 2000 athttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp There is also a very short article at: http://www.databasejournal.com/features/mssql/article.php/1469841 Regards Jerry Henzel
> Date: Thu, 6 Jul 2006 10:34:49 -0700> From: [EMAIL PROTECTED]> To: > [email protected]> Subject: Re: MS-SQL Database problem> > > Ton-> > Monday, July 3, 2006, 9:37:30 AM, you wrote:> > > Hi, fellow > Revolutionaires...> > > I have a strange problem:> > > I'm using RR 2.7.2 > Enterprise on OS X 10.4.7> > > I'm connecting to a SQL Server through an ODBC > connection, no problem> > so far.> > When I retrieve data from the SQL > Server, all fields come over just> > fine, except DateTime fields...> > > > There are 2 of these fields, each containing a value like "28-06-2006> > > 00:00"> > > When I use the code below to get the data, the value I get for > the> > date is truncated and changed to "2006-06-"...> > DateTime formats on > SQLServer are IMO a bit weird, and I've run into> conversion problems with > them before, too. Not just in rev. I believe> SQLServer by default uses MDY > encoding, which might explain why it's> stopping when it gets to trying to > convert the 28th month. You can> issue a DATEFORMAT command to SQLServer on a > per-connection basis to> change this, no matter what format the dates are > stored in:> > SET DATEFORMAT DMY> > -- > -Mark Wieder> [EMAIL PROTECTED]> > > _______________________________________________> use-revolution mailing list> > [email protected]> Please visit this url to subscribe, > unsubscribe and manage your subscription preferences:> > http://lists.runrev.com/mailman/listinfo/use-revolution _________________________________________________________________ Try Live.com - your fast, personalized homepage with all the things you care about in one place. http://www.live.com/getstarted_______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
