نمایش ساعت در تابع

[Iran58]

سلام
در تابع زیر چگونه می توانم ساعت هم به این تابع اضافه کنم هنگام دریافت خروجی
ALTER FUNCTION [dbo].[PrDate] (@MDate DateTime)
RETURNS Varchar(20)
AS
BEGIN
DECLARE @SYear as Integer
DECLARE @SMonth as Integer
DECLARE @SDay as Integer
DECLARE @AllDays as float
DECLARE @ShiftDays as float
DECLARE @OneYear as float
DECLARE @LeftDays as float
DECLARE @YearDay as Integer
DECLARE @Farsi_Date as Varchar(100)
SET @MDate=@MDate-CONVERT(char,@MDate,114)

SET @ShiftDays=466699 +2
SET @OneYear= 365.24199


SET @SYear = 0
SET @SMonth = 0
SET @SDay = 0
SET @AllDays = CAst(@Mdate as Real)

SET @AllDays = @AllDays + @ShiftDays

SET @SYear = (@AllDays / @OneYear) --trunc
SET @LeftDays = @AllDays - @SYear * @OneYear

if (@LeftDays < 0.5)
begin
SET @SYear=@SYear+1
SET @LeftDays = @AllDays - @SYear * @OneYear
end;

SET @YearDay = @LeftDays --trunc
if (@LeftDays - @YearDay) >= 0.5
SET @YearDay=@YearDay+1

if ((@YearDay / 31) > 6 )
begin
SET @SMonth = 6
SET @YearDay=@YearDay-(6 * 31)
SET @SMonth= @SMonth+( @YearDay / 30)
if (@YearDay % 30) <> 0
SET @SMonth=@SMonth+1
SET @YearDay=@YearDay-((@SMonth - 7) * 30)
end
else
begin
SET @SMonth = @YearDay / 31
if (@YearDay % 31) <> 0
SET @SMonth=@SMonth+1
SET @YearDay=@YearDay-((@SMonth - 1) * 31)
end
SET @SDay = @YearDay
SET @SYear=@SYear+1

SET @Farsi_Date = CAST (@SYear as VarChar(20)) + '/' + CAST (@SMonth as VarChar(20)) + '/' + CAST (@SDay as VarChar(20))
Return @Farsi_Date
END

[mohammad reza beizavi]

Return @Farsi_Date + ' ' + convert(char, cast(GETDATE() as time))

[mohammad reza beizavi]

درود بر دوستان
اگر بخواید خروجی بجای 1392/2/3 به اینصورت باشه: 1392/02/03 آخر کوئری رو اینجور تغییر بدید:


SET @Farsi_Date = CAST (@SYear as VarChar(20)) + '/' + RIGHT('00'+CAST (@SMonth as VarChar(20)),2) + '/' + RIGHT('00'+CAST (@SDay as VarChar(20)),2)


توجهتون رو به این تاپیک هم جلب می کنم:
بهترین روش برای ذخیره تاریخ فارسی (http://barnamenevis.org/showthread.php?467670-%D8%A8%D9%87%D8%AA%D8%B1%DB%8C%D9%86-%D8%B1%D9%88%D8%B4-%D8%A8%D8%B1%D8%A7%DB%8C-%D8%B0%D8%AE%DB%8C%D8%B1%D9%87-%D9%81%DB%8C%D9%84%D8%AF%D9%87%D8%A7%DB%8C-%D8%AA%D8%A7%D8%B1%DB%8C%D8%AE)