quote:

---

Originally posted by Exir

Hi
Is it a true query for changing @SMonth ?
If @SMonth=1 i want it to change to 01 , if @SMonth=2 then change to 02 and so on

SELECT @SMonth=
CASE
WHEN @SMonth=1 THEN 01
WHEN @SMonth=2 THEN 02
WHEN @SMonth=3 THEN 03
WHEN @SMonth=4 THEN 04
END

thank you

---

quote:

---

Originally posted by khtan

quote:

---

Originally posted by Exir

Hi
Is it a true query for changing @SMonth ?
If @SMonth=1 i want it to change to 01 , if @SMonth=2 then change to 02 and so on

SELECT @SMonth=
CASE
WHEN @SMonth=1 THEN 01
WHEN @SMonth=2 THEN 02
WHEN @SMonth=3 THEN 03
WHEN @SMonth=4 THEN 04
END

thank you

---

what is the purpose of this ?

---

KH
[spoiler]Time is always against us[/spoiler]

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER FUNCTION [dbo].[MiladiTOShamsi] (@MDate  DateTime)  
RETURNS Varchar(10)
AS  
BEGIN 
   DECLARE @SYear  as Integer
   DECLARE @SMonth  as nvarchar(2)
   DECLARE @SDay  as  nvarchar(2)
   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

//------------------INSERTED PART
select @SDay= 
CASE       
WHEN  @SDay='1' THEN '01'   
WHEN  @SDay='2' THEN '02'  
WHEN  @SDay='3' THEN '03' 
WHEN  @SDay='4' THEN '04' 
WHEN  @SDay='5' THEN '05' 
WHEN  @SDay='6' THEN '06' 
WHEN  @SDay='7' THEN '07' 
WHEN  @SDay='8' THEN '08'
WHEN  @SDay='9' THEN '09'  
END 
 
select @SMonth= 
CASE       
WHEN  @SMonth='1' THEN '01'   
WHEN  @SMonth='2' THEN '02'  
WHEN  @SMonth='3' THEN '03' 
WHEN  @SMonth='4' THEN '04'
WHEN  @SMonth='5' THEN '05' 
WHEN  @SMonth='6' THEN '06' 
WHEN  @SMonth='7' THEN '07' 
WHEN  @SMonth='8' THEN '08'
WHEN  @SMonth='9' THEN '09'  
END  
//------------------------------
 
 SET @Farsi_Date =   CAST (@SYear   as VarChar(10)) + '/' + CAST (@SMonth   as VarChar(10)) + '/' + CAST (@SDay  as VarChar(10))
 Return @Farsi_Date



END

quote:

---

Originally posted by khtan

Having the month in 02 and not 2 means it will be in string / varchar. How are you going to perform any calculation on the date ?

Anyway "02 not 2" is more of a presentation issue and should be handled in your client application

---

KH
[spoiler]Time is always against us[/spoiler]

---

quote:

---

I can not use date/time , becouse my country date is not the date which getdate() returns and i have to convert it.

---

quote:

---

DECLARE @SYear as Integer
DECLARE @SMonth as nvarchar(2)
DECLARE @SDay as nvarchar(2)

---

quote:

---

SET @MDate=@MDate-CONVERT(char,@MDate,114)

---

quote:

---

SET @AllDays = CAst(@Mdate as Real)

---