In SQL Server 2014 , how to convert given UTC date time to PST date time, when the server is in UTC

up vote
-1
down vote

favorite

How to convert given UTC date time to PST date time, by keeping the daylight stuff in time calculations?

Note that the server I am hitting is in utc. I mean, GETDATE() = GETUTCDATE().

Also, we can't use AT TIME ZONE, as DB is on older SQL Server.

Thanks in advance for the help.

edited Nov 9 at 5:20

marc_s

565k12610921245

asked Nov 8 at 22:57

RaturiMic

206

What version of SQL exactly? What makes you think we can suggest correct syntax if we don't know what version you are on?
– Nick.McDermaid
Nov 8 at 23:20

sorry it was sql server 2014
– RaturiMic
Nov 8 at 23:49

1

Possible duplicate of Convert Datetime column from UTC to local time in select statement
– user6655984
Nov 9 at 0:15

add a comment |

up vote
-1
down vote

favorite

How to convert given UTC date time to PST date time, by keeping the daylight stuff in time calculations?

Note that the server I am hitting is in utc. I mean, GETDATE() = GETUTCDATE().

Also, we can't use AT TIME ZONE, as DB is on older SQL Server.

Thanks in advance for the help.

edited Nov 9 at 5:20

marc_s

565k12610921245

asked Nov 8 at 22:57

RaturiMic

206

What version of SQL exactly? What makes you think we can suggest correct syntax if we don't know what version you are on?
– Nick.McDermaid
Nov 8 at 23:20

sorry it was sql server 2014
– RaturiMic
Nov 8 at 23:49

1

Possible duplicate of Convert Datetime column from UTC to local time in select statement
– user6655984
Nov 9 at 0:15

add a comment |

up vote
-1
down vote

favorite

How to convert given UTC date time to PST date time, by keeping the daylight stuff in time calculations?

Note that the server I am hitting is in utc. I mean, GETDATE() = GETUTCDATE().

Also, we can't use AT TIME ZONE, as DB is on older SQL Server.

Thanks in advance for the help.

edited Nov 9 at 5:20

marc_s

565k12610921245

asked Nov 8 at 22:57

RaturiMic

206

How to convert given UTC date time to PST date time, by keeping the daylight stuff in time calculations?

Note that the server I am hitting is in utc. I mean, GETDATE() = GETUTCDATE().

Also, we can't use AT TIME ZONE, as DB is on older SQL Server.

Thanks in advance for the help.

tsql sql-server-2014 utc

edited Nov 9 at 5:20

marc_s

565k12610921245

asked Nov 8 at 22:57

RaturiMic

206

edited Nov 9 at 5:20

marc_s

565k12610921245

asked Nov 8 at 22:57

RaturiMic

206

edited Nov 9 at 5:20

marc_s

565k12610921245

edited Nov 9 at 5:20

marc_s

565k12610921245

edited Nov 9 at 5:20

marc_s

565k12610921245

asked Nov 8 at 22:57

RaturiMic

206

asked Nov 8 at 22:57

RaturiMic

206

asked Nov 8 at 22:57

RaturiMic

206

What version of SQL exactly? What makes you think we can suggest correct syntax if we don't know what version you are on?
– Nick.McDermaid
Nov 8 at 23:20

sorry it was sql server 2014
– RaturiMic
Nov 8 at 23:49

1

Possible duplicate of Convert Datetime column from UTC to local time in select statement
– user6655984
Nov 9 at 0:15

add a comment |

What version of SQL exactly? What makes you think we can suggest correct syntax if we don't know what version you are on?
– Nick.McDermaid
Nov 8 at 23:20

sorry it was sql server 2014
– RaturiMic
Nov 8 at 23:49

1

Possible duplicate of Convert Datetime column from UTC to local time in select statement
– user6655984
Nov 9 at 0:15

What version of SQL exactly? What makes you think we can suggest correct syntax if we don't know what version you are on?
– Nick.McDermaid
Nov 8 at 23:20

sorry it was sql server 2014
– RaturiMic
Nov 8 at 23:49

Possible duplicate of Convert Datetime column from UTC to local time in select statement
– user6655984
Nov 9 at 0:15

add a comment |

1 Answer
1

active

oldest

votes

up vote
1
down vote

accepted

Search the site, example: Convert Datetime column from UTC to local time in select statement

Read the link above, also include daylight stuff in there for some of the responses too.

answered Nov 8 at 23:04

Noogen

1,29299

yep yep yep .... thanks for the link noogen.
– RaturiMic
Nov 8 at 23:39

copied the query from @Aiden Kaskela : select CONVERT(datetime, SWITCHOFFSET(yourdate, DATEPART(TZOFFSET, yourdate AT TIME ZONE 'Pacific Standard Time')))
– RaturiMic
Nov 8 at 23:51

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53217427%2fin-sql-server-2014-how-to-convert-given-utc-date-time-to-pst-date-time-when-t%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
1
down vote

accepted

Search the site, example: Convert Datetime column from UTC to local time in select statement

Read the link above, also include daylight stuff in there for some of the responses too.

answered Nov 8 at 23:04

Noogen

1,29299

yep yep yep .... thanks for the link noogen.
– RaturiMic
Nov 8 at 23:39

copied the query from @Aiden Kaskela : select CONVERT(datetime, SWITCHOFFSET(yourdate, DATEPART(TZOFFSET, yourdate AT TIME ZONE 'Pacific Standard Time')))
– RaturiMic
Nov 8 at 23:51

add a comment |

up vote
1
down vote

accepted

Search the site, example: Convert Datetime column from UTC to local time in select statement

Read the link above, also include daylight stuff in there for some of the responses too.

answered Nov 8 at 23:04

Noogen

1,29299

yep yep yep .... thanks for the link noogen.
– RaturiMic
Nov 8 at 23:39

copied the query from @Aiden Kaskela : select CONVERT(datetime, SWITCHOFFSET(yourdate, DATEPART(TZOFFSET, yourdate AT TIME ZONE 'Pacific Standard Time')))
– RaturiMic
Nov 8 at 23:51

add a comment |

up vote
1
down vote

accepted

Search the site, example: Convert Datetime column from UTC to local time in select statement

Read the link above, also include daylight stuff in there for some of the responses too.

answered Nov 8 at 23:04

Noogen

1,29299

Search the site, example: Convert Datetime column from UTC to local time in select statement

Read the link above, also include daylight stuff in there for some of the responses too.

answered Nov 8 at 23:04

Noogen

1,29299

answered Nov 8 at 23:04

Noogen

1,29299

answered Nov 8 at 23:04

Noogen

1,29299

answered Nov 8 at 23:04

Noogen

1,29299

yep yep yep .... thanks for the link noogen.
– RaturiMic
Nov 8 at 23:39

copied the query from @Aiden Kaskela : select CONVERT(datetime, SWITCHOFFSET(yourdate, DATEPART(TZOFFSET, yourdate AT TIME ZONE 'Pacific Standard Time')))
– RaturiMic
Nov 8 at 23:51

add a comment |

yep yep yep .... thanks for the link noogen.
– RaturiMic
Nov 8 at 23:39

copied the query from @Aiden Kaskela : select CONVERT(datetime, SWITCHOFFSET(yourdate, DATEPART(TZOFFSET, yourdate AT TIME ZONE 'Pacific Standard Time')))
– RaturiMic
Nov 8 at 23:51

yep yep yep .... thanks for the link noogen.
– RaturiMic
Nov 8 at 23:39

copied the query from @Aiden Kaskela : select CONVERT(datetime, SWITCHOFFSET(yourdate, DATEPART(TZOFFSET, yourdate AT TIME ZONE 'Pacific Standard Time')))
– RaturiMic
Nov 8 at 23:51

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk