MS-SQL Database problem

[precipice development]

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: mwieder at ahsoftware.net> To: use-revolution at lists.runrev.com> 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>  mwieder at ahsoftware.net> > _______________________________________________> use-revolution mailing list> use-revolution at lists.runrev.com> 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