Converting Hijri Date

Question

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

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

mohammed jameel-448990 SSC Rookie Points: 32 More actions · Answer 1

SSC Rookie

Points: 32

March 15, 2011 at 11:53 pm

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

innosys Grasshopper Points: 11 More actions · Answer 2

Declare @Hdate nvarchar(50)

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

Smile Please

innosys Grasshopper Points: 11 More actions · Answer 3

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: 182916 More actions · Answer 4

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

😎

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