
September 25th, 2003, 07:28 AM
|
|
Junior Member
|
|
Join Date: Sep 2003
Location: Sweden
Posts: 6
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
date function
How do I change this function so that it shows dates like this 2003-05-03 and not 2003-5-3?
And I also want to add a parameter so that the user can choose if it should show :
2003-03-03 or 03-03-03
create function ShowDate(@indate datetime, @separator char(1))
returns nchar(20)
as
begin
return
convert(nvarchar(20), datepart(yyyy, @indate))
+ @separator
+ convert(nvarchar(20), datepart(mm, @indate))
+ @separator
+ convert(nvarchar(20), datepart(dd, @indate))
end
|