i get an error on the "convert" when i try to run this line...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by shugarhi
Submitted on 7/14/2003
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating: Not yet rated	Rate this question:
i get an error on the "convert" when i try to run this line of code, why is this? print 'Starting storedprocedure At ', convert(char(20),getdate(), 113)

Answer by sethu
Submitted on 4/20/2004
Rating: Not yet rated	Rate this answer:
style '113' is not valid

Answer by sengodan
Submitted on 4/28/2004
Rating: Not yet rated	Rate this answer:
Style 113 is valid. Assign that converted value to a variable set @x=convert(char(20),getdate(),113) and then print the variable. print @x

Answer by manjusha
Submitted on 2/25/2006
Rating: Not yet rated	Rate this answer:
Please try following one declare @x char(10) @x = convert(char(10),getdate(),103) print 'Starting storedprocedure At:' @x

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: