5 pts. datetime conversion
DateTime, SQL Query Analyzer
SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem?convert(varchar(10),ft.postdate,101) 'PostDate',
Question
DateTime, SQL Query Analyzer
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 Development and SQL Server.
Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.
