Converting Hijri Date

  • ------------

  • Declare @Hdate nvarchar(50)

    set @Hdate = convert(varchar(10),convert(date,convert(varchar(12),getdate(),131),103),112)

    Smile Please
  • this help me a lot

    Declare @Hdate nvarchar(50)

    set @Hdate = convert(varchar(10),convert(date,convert(varchar(12),getdate(),131),103),112)

    Smile Please
  • This should do the trick, no need to convert to a varchar

    😎

    SELECT convert(date,convert(varchar(12),getdate(),131),103) AS AH_DATE

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply