Post reply

Converting Hijri Date

  • March 15, 2011 at 11:53 pm

    #1299220

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

  • June 10, 2019 at 4:04 am

    #3651689

    Declare @Hdate nvarchar(50)

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

    Kamu bisa beli emas dengan cara menghubungi (CS) Flip.id WhatsApp: +62811143124 atau 085129661640. Layanan pengaduan konsumen Flip ini beroperasi 24 Jam. Ada pertanyaan terkait kendala transaksi Flip? Hubungi kami sekarang.

  • June 10, 2019 at 4:05 am

    #3651690

    this help me a lot

    Declare @Hdate nvarchar(50)

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

    Kamu bisa beli emas dengan cara menghubungi (CS) Flip.id WhatsApp: +62811143124 atau 085129661640. Layanan pengaduan konsumen Flip ini beroperasi 24 Jam. Ada pertanyaan terkait kendala transaksi Flip? Hubungi kami sekarang.

  • June 10, 2019 at 12:57 pm

    #3651789

    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