Like I suggested on the other thread, Manish, open a separate thread for your own question.

[EDIT]...

Correct, you convert the local time to UTC then perform the conversion to Unix timestamp.

In fact, the numeric timestamp is only UTC by convention.  There is nothing inherent in...

You should open your own post, Manish, so that it doesn't "get...

Back in the '90's at work, I had to have a reel to reel tape reader, a CD reader, a special optical reader, and multiple floppy drives, and a special...

"It Depends" on what you're talking about.  If you're on Eastern Time and you want the correct data based on a UNIX timestamp, then you need to convert your local...

I am not even sure what your function is trying to do here - or why you would even care about UTC.  The UNIX timestamp is an offset in...

The new STRING_SPLIT with the 3rd operand is great for this.  The old STRING_SPLIT without it is not.  Even MS has stated that the order of the output is NOT...

And what kind of stored procedure?  Is it for DBAs/Maintenance, etc or is it "production" code or ???

Agreed.

If I'm understanding what you wrote above correctly (it's...

Most of these are not SARGable.  I wonder if the TIME conversion is (Like DATE and DATETIME supposedly is).

If this is a regular thing, I'm with Piet... persisted computed column.

Hi jeff thanks for advice , i went by website you suggested geeks for geeks and i found it to more for programmers . .I didnt see anything related...

Thanks for the update, Steve.

And, I didn't read Jeffrey Williams post before I posted (I was responding to a post on the first page of this thread).  He's spot on about the Unix TimeStamp...

Insert Into Tag_Data_Capture_staging
(TagName,CaptureValue,DateRecorded)
select * 
from OPENQUERY(srv1, 'select tagid,floatvalue,DATEADD(s,t_stamp/1000,''1969-12-31 20:00:00'') from rem.ignition.dbo.sqlt_data_1_2021_12
where DATEADD(s,t_stamp/1000,''1969-12-31 20:00:00'') between  ''12-09-2021'' AND ''12-10-2021'' and floatvalue is not null');

I did the Insert...