March 15, 2011 at 11:53 pm
------------
June 10, 2019 at 4:04 am
Declare @Hdate nvarchar(50)
set @Hdate = convert(varchar(10),convert(date,convert(varchar(12),getdate(),131),103),112)
Smile Please
June 10, 2019 at 4:05 am
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
June 10, 2019 at 12:57 pm
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 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply