Posted by Erland Sommarskog on 02/22/07 14:30

(paulmac106@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Insert Date as Formatted String
• Prev in forum: Insert Date as Formatted String
• Thread view: Re: Insert Date as Formatted String

[Reply to this message]