I got your point on omitting the offset field.  Based on the week day, we can populate date and concatenate with time field. Thank you for clearing this out.

• This reply was modified 3 years, 8 months ago by  Rock.

The date expected is always less than current date. For your queries, here is my reply.

At Time Zone is not available in 2012

In the example - the expected return is...

• This reply was modified 3 years, 8 months ago by  Rock.

This works perfectly.  A little change in the output. If I pass TestDate as Today. It has to get me Thursday (follows with 2nd Tue - 12 Nov 2020) of...

• This reply was modified 3 years, 11 months ago by  Rock.

fnTally function is not available. Can you help me? - I'm intended to get Thursday of a month which is followed with 2nd Tuesday

I have 2012 version. How do I accomplish the offset value based on day light savings.

DECLARE @Texxt Varchar(50);

SET @Texxt = 'Wed, 15 Apr 2020 02:00:00 -0400';

SELECT @Texxt as original,

SUBSTRING(STUFF(@Texxt,1,5,''),1,DATALENGTH(STUFF(@Texxt,1,5,''))-5) convertedone

Done!!!

14 Apr 2020 23:00:01 +0000

15 Apr 2020 03:58:49 -0400

15 Apr 2020 02:00:00 -0400

15 Apr 2020 03:00:04 -0400

14 Apr 2020 12:00:00 -0400

I used the stuff to replace the first 4 char...

I didn't do that. How will I do that?

I'm using 2012.

SELECT SYSDATETIMEOFFSET() AT TIME ZONE 'India Standard Time' AS [FullISTDateTime],

convert(time, SYSDATETIMEOFFSET() AT TIME ZONE 'India Standard Time') AS [ISTCurrentTime];

This returns incorrect syntax near 'TIME'

Issue Resolved

DECLARE @Hostnames VARCHAR(max)

Select @Hostnames = concat('''', stuff((select ', ' + ServerName from #serverinput for xml path ('')), 1, 2, ''), '''');

select @Hostnames

Invalid object name 'server_cte'

how do i set this to a local varabile in sql server

I used this, it doesnt work.

Declare @localvariable varchar(max)

;with

server_cte(ServerName) as (select 'Server1' union all select 'Server2')

select

concat('''', stuff((select ', ' +...

It doesnt work.

The o/p should be like this

'Server1,server2,server3'

The current result is

Server1, server2, server3

The Above sample one works fine as it is. When I include it in my SP. It throws the below error.

The conversion of a nvarchar data type to a datetime...

• This reply was modified 4 years, 11 months ago by  Rock.

Any suggestion