Viewing 3 posts - 1 through 3 (of 3 total)
this help me a lot
Declare @Hdate nvarchar(50)
set @Hdate = convert(varchar(10),convert(date,convert(varchar(12),getdate(),131),103),112)
June 10, 2019 at 4:05 am
#3651690
June 10, 2019 at 4:04 am
#3651689
SELECT CONVERT(DATE, CURRENT_TIMESTAMP)declare @time as timeset @time = CONVERT(Time, CURRENT_TIMESTAMP)SELECT @time
January 16, 2019 at 7:30 pm
#2019176