Home > IT Answers > Development > datetime conversion
Mictip
5 pts.
0
Q:
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',
ASKED: May 5 2008  3:31 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
RudyLimeback
440 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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?
Last Answered: May 6 2008  7:27 PM GMT by RudyLimeback   440 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0