Question

Asked:
Asked By:
May 5 2008   3:31 PM GMT
Mictip   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',

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
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?
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register