Converting Hijri Date

  • mohammed jameel-448990

    SSC Rookie

    Points: 32

    ------------

  • innosys

    Grasshopper

    Points: 11

    Declare @Hdate nvarchar(50)

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

    Smile Please
  • innosys

    Grasshopper

    Points: 11

    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
  • Eirikur Eiriksson

    SSC Guru

    Points: 182344

    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