Posted by paulmac106 on 02/22/07 14:22
Hello,
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)
Any ideas?
thanks so much!
[Back to original message]
|