Try_Convert Datetime showing '1/1/1900', want to show space
Why does Surtur say that Thor is Asgard's doom?
Why didn’t Eve recognize the little cockroach as a living organism?
How to read string as hex number in bash?
How do researchers send unsolicited emails asking for feedback on their works?
Why didn't Héctor fade away after this character died in the movie Coco?
Why are there no stars visible in cislunar space?
Would it be believable to defy demographics in a story?
How to test the sharpness of a knife?
Single word to change groups
How can an organ that provides biological immortality be unable to regenerate?
What are rules for concealing thieves tools (or items in general)?
What is the tangent at a sharp point on a curve?
Do people actually use the word "kaputt" in conversation?
Should a narrator ever describe things based on a characters view instead of fact?
Should I be concerned about student access to a test bank?
Animating wave motion in water
CLI: Get information Ubuntu releases
How can I create URL shortcuts/redirects for task/diff IDs in Phabricator?
When should a starting writer get his own webpage?
Knife as defense against stray dogs
Norwegian Refugee travel document
Why is this tree refusing to shed its dead leaves?
Have the tides ever turned twice on any open problem?
Friend wants my recommendation but I don't want to
Try_Convert Datetime showing '1/1/1900', want to show space
How do I get try_convert datetime to display NULL when the input is space?
I am getting two different results here. My intention is to show 'space' number query as Null also, just like first query.
select try_convert(datetime,'abcd') ---> Null
select try_convert(datetime,'') ---> '1/1/1900'
sql-server sql-server-2016 convert isnull
asked 3 mins ago
Joe SmithJoe Smith
296
add a comment |
How do I get try_convert datetime to display NULL when the input is space?
I am getting two different results here. My intention is to show 'space' number query as Null also, just like first query.
select try_convert(datetime,'abcd') ---> Null
select try_convert(datetime,'') ---> '1/1/1900'
sql-server sql-server-2016 convert isnull
asked 3 mins ago
Joe SmithJoe Smith
296
add a comment |
How do I get try_convert datetime to display NULL when the input is space?
I am getting two different results here. My intention is to show 'space' number query as Null also, just like first query.
select try_convert(datetime,'abcd') ---> Null
select try_convert(datetime,'') ---> '1/1/1900'
sql-server sql-server-2016 convert isnull
asked 3 mins ago
Joe SmithJoe Smith
296
How do I get try_convert datetime to display NULL when the input is space?
I am getting two different results here. My intention is to show 'space' number query as Null also, just like first query.
select try_convert(datetime,'abcd') ---> Null
select try_convert(datetime,'') ---> '1/1/1900'
sql-server sql-server-2016 convert isnull
sql-server sql-server-2016 convert isnull
asked 3 mins ago
Joe SmithJoe Smith
296
asked 3 mins ago
Joe SmithJoe Smith
296
asked 3 mins ago
Joe SmithJoe Smith
296
asked 3 mins ago
Joe SmithJoe Smith
296
asked 3 mins ago
Joe SmithJoe Smith
296
296
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232478%2ftry-convert-datetime-showing-1-1-1900-want-to-show-space%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232478%2ftry-convert-datetime-showing-1-1-1900-want-to-show-space%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
