datetime conversion
SQL Query Analyzer, DateTime
SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem?convert(varchar(10),ft.postdate,101) 'PostDate',
Question
SQL Query Analyzer, DateTime
SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem?convert(varchar(10),ft.postdate,101) 'PostDate',
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
the syntax looks fine, the only problem i can think of is that ft.postdate is not a proper DATETIME column...
any chance you can tell us the exact error message?
Browse more Questions and Answers on SQL Server and Development.
Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.
