| Subject: | Re: Different result from same SQL statement |
|---|---|
| From: | "paross1" <webforumsuser@xxxxxxxxxxxxxx> |
| Date: | Wed, 23 Jan 2008 15:02:09 +0000 (UTC) |
| Newsgroups: | macromedia.coldfusion.database_access |
Perhaps SQL Server is performing an implicit type conversion with your date values to a date/time datatype when the query is run via the query analyzer, but that conversion is not happening from ColdFusion. What happens if you explicitly CAST() your date "strings" to datetime? Phil |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Different result from same SQL statement, Anthony Spears |
|---|---|
| Next by Date: | Re: ora-00933 with JDBC thin, paross1 |
| Previous by Thread: | Different result from same SQL statement, Anthony Spears |
| Next by Thread: | Re: Different result from same SQL statement, Anthony Spears |
| Indexes: | [Date] [Thread] [Top] [All Lists] |