How can I set my timestamp to a specific time zone, particularly US/Pacific?
Consider this MWE:
CREATE TABLE #timingTable (theTime datetime2(0))
INSERT INTO #timingTable
SELECT (SELECT CURRENT_TIMESTAMP);
SELECT * FROM #timingTable;How can I set my timestamp to a specific time zone, particularly US/Pacific?
Consider this MWE:
CREATE TABLE #timingTable (theTime datetime2(0))
INSERT INTO #timingTable
SELECT (SELECT CURRENT_TIMESTAMP);
SELECT * FROM #timingTable;