Posted by paulmac106 on 02/22/07 14:53

On Feb 22, 9:30 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (paulmac...@gmail.com) writes:
> > I thought this would be easy, and I've read a lot of posts, but I
> > can't seem to find exactly what I'm trying to do.
>
> >>From within a stored procedure I would like to insert a date value
> > into another table to a Char(8) field....but I want the value to be
> > formatted as YYYYMMDD (specifically no "/"'s)
>
> > Insert into Temp (sFromDate) Values (getdate()) (20070221)
>
> convert(char(8), getdate(), 112)
>
> Read more about Convert under the topic CAST and CONVERT in Books Online.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Perfect! Thank you!!

• Next in forum: Re: Is there a Query Analyzer
• Prev in forum: Re: Insert Date as Formatted String
• Thread view: Re: Insert Date as Formatted String

[Reply to this message]