SELECT Line001 + '|' + cast(datepart(yyyy,getdate()) as varchar) +
right('0' + cast(datepart(mm,getdate()) as varchar),2) +
right('0' + cast(datepart(dd,getdate()) as varchar),2)
FROM TableName

----- Original Message -----
From: "Justin Gilli" <[Email Address Removed] "Jonas Skafte Jensen" <[Email Address Removed] Monday, August 25, 2003 3:59 PM
Subject: RE: Stored Procedure Help


This works for me. How would I convert the date format from Aug 25, 2003 to
20030825 (yyyyMMdd) ?

Sincerely,

Justin Gilli
Systems Administrator
Wood Flooring International
1810 Underwood Blvd.
Delran, NJ 08075
856-764-2501 ext. 119
856-705-1177 (direct fax)
[Email Address Removed] (e-mail)
www.wflooring.com (web)






-----Original Message-----
From: Jonas Skafte Jensen [mailto:[Email Address Removed] Monday, August 25, 2003 8:47 AM
To: LazyDBA.com Discussion
Subject: Re: Stored Procedure Help

Maybe something like:

SELECT Line001 + '|' + cast(getdate() as varchar) FROM TableName


HtH

Jonax
----- Original Message -----
From: "Justin Gilli" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, August 25, 2003 3:23 PM
Subject: Stored Procedure Help


I am looking to append a date variable in a stored procedure.
For example I have a table with a column named Line001
I want to show the column results but also append the current date,
something like - "ResultsLine001|082503"

Any advice?

Sincerely,

Justin Gilli






---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page