This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQL Server: Cast not a valid function Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server: Cast not a valid function" Watch "SQL Server: Cast not a valid function" New topic
Author

SQL Server: Cast not a valid function

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi,
Anyone have any thoughts on way I get this SQL error message:
'CAST' is not a recognized function name.
Produced by:
rs = stmt.executeQuery("SELECT CAST(START_DATE AS NCHAR(50)) AS T FROM TISCOURSES");

Thanks for your help.
Yoo-Jin.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server: Cast not a valid function
 
It's not a secret anymore!