Posted by v0lcan0 on 10/13/05 03:28

"" wrote:
> Am 6 Oct 2005 17:36:46 -0400 schrieb v0lcan0:
>
> > I�m trying to cast and integer type to a varchar and then
> concatenate
> > two varchar and �01� and convert it into datetime with the
> following
> > code:
> >
> > CONVERT(datetime, { fn CONCAT({ fn CONCAT(CAST(PeriodYear AS
> varchar),
> > CAST(PeriodMonth AS varchar)) }, �01�) }, 112) AS date
> >
> > It gives an error saying syntax error converting datetime
> from
> > character string.
> >
> > Any help appreciated!!
> >
> > thx..
>
> If PeriodMonth is < 10 then the result in your statement would
> be something
> like 2005701, which is an invalid datae indeed. And why
> concat? A simple
> "+" is enough. For example:
> select CONVERT(datetime,CAST(PeriodYear AS varchar) +
> RIGHT('0' + CAST(PeriodMonth AS varchar),2) + '01', 112) AS
> date
> should do the job, if year and month are valid values.
>
> bye,
> Helmut

thx helmut...being a new SQL programmer, your suggestion is really
worthwhile.

thanks again

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Discussions-SQL-Convert-function-ftopict261333.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=904392

• Next in forum: Re: AutoNumber vs. Key
• Prev in forum: Re: Re: SQL Convert function!!
• Thread view: Re: Re: SQL Convert function!!

[Reply to this message]