A simple cast to datetime should do the trick.

Create and populate sample table (Please save us this step in your future questions):

CREATE TABLE MyTable 
(
  MyTableMyDateColumn DateTime
);

INSERT INTO MyTable (MyTableMyDateColumn) VALUES 
(GETUTCDATE()), 
(GETDATE());

The query:

SELECT MyTableMyDateColumn,
       MyTableMyDateColumn AT TIME ZONE 'GMT Standard Time' As GMT, 
       MyTableMyDateColumn AT TIME ZONE 'Pacific Standard Time' AS PST,
       -- doing "at time zone" twice is redundant, as you can see in the results
       MyTableMyDateColumn AT TIME ZONE 'GMT Standard Time' AT TIME ZONE 'Pacific Standard Time' AS OrderDate, 
       CAST (MyTableMyDateColumn AT TIME ZONE 'Pacific Standard Time' As DATETIME) As PSTDateTime
FROM MyTable;

Results:

See a live demo on db<>fiddle