localtimestamp or curent_timestamp for default valueHow to create an UTC index from a 'DATE' typed column...
LED on same Pin as Toggle Switch, not illuminating
Why has Russell's definition of numbers using equivalence classes been finally abandoned? ( If it has actually been abandoned).
How do you conduct xenoanthropology after first contact?
How to make payment on the internet without leaving a money trail?
Chess with symmetric move-square
What does "enim et" mean?
least quadratic residue under GRH: an EXPLICIT bound
How can bays and straits be determined in a procedurally generated map?
A function which translates a sentence to title-case
Why is "Reports" in sentence down without "The"
Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?
declaring a variable twice in IIFE
What makes Graph invariants so useful/important?
Can I make popcorn with any corn?
Mean and Variance of Continuous Random Variable
Patience, young "Padovan"
XeLaTeX and pdfLaTeX ignore hyphenation
I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine
Circuitry of TV splitters
Why CLRS example on residual networks does not follows its formula?
Prevent a directory in /tmp from being deleted
Can a German sentence have two subjects?
Can an x86 CPU running in real mode be considered to be basically an 8086 CPU?
Can town administrative "code" overule state laws like those forbidding trespassing?
localtimestamp or curent_timestamp for default value
How to create an UTC index from a 'DATE' typed column with Oracle?How to compare (in MySQL) a DATETIME value to a TIMESTAMP value?Convert a Unix timestamp to a DATETIME in a ViewLogic to convert a UTC date-time to a specific time zoneHow to convert a unix time to PostgreSQL' Timstamp without timezome?Why is add timestamp column with default not null so slow in Oracle 11g?Constrain Partial Values in TimestampAutomatically set timestamps for “create” and “modified”?Formatting Timestamp in Default ConstraintMySQL - Change Default TimeZone changed all values in TIMESTAMP column
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
In Oracle-12c I have some columns that I am converting from timestamp with time zone to timestamp with local time zone. Some of those same columns also currently have a default value of CURRENT_TIMESTAMP. Should I change the default values to use the LOCALTIMESTAMP function instead? The columns seem to populate fine if I just leave the CURRENT_TIMESTAMP default values. Is there any practical reasons or gotchas for using one over the other in this case. I have been combing the docs but can't find anything.
oracle timestamp
asked Apr 18 '16 at 16:39
user27643user27643
1011
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
In Oracle-12c I have some columns that I am converting from timestamp with time zone to timestamp with local time zone. Some of those same columns also currently have a default value of CURRENT_TIMESTAMP. Should I change the default values to use the LOCALTIMESTAMP function instead? The columns seem to populate fine if I just leave the CURRENT_TIMESTAMP default values. Is there any practical reasons or gotchas for using one over the other in this case. I have been combing the docs but can't find anything.
oracle timestamp
asked Apr 18 '16 at 16:39
user27643user27643
1011
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
In Oracle-12c I have some columns that I am converting from timestamp with time zone to timestamp with local time zone. Some of those same columns also currently have a default value of CURRENT_TIMESTAMP. Should I change the default values to use the LOCALTIMESTAMP function instead? The columns seem to populate fine if I just leave the CURRENT_TIMESTAMP default values. Is there any practical reasons or gotchas for using one over the other in this case. I have been combing the docs but can't find anything.
oracle timestamp
asked Apr 18 '16 at 16:39
user27643user27643
1011
In Oracle-12c I have some columns that I am converting from timestamp with time zone to timestamp with local time zone. Some of those same columns also currently have a default value of CURRENT_TIMESTAMP. Should I change the default values to use the LOCALTIMESTAMP function instead? The columns seem to populate fine if I just leave the CURRENT_TIMESTAMP default values. Is there any practical reasons or gotchas for using one over the other in this case. I have been combing the docs but can't find anything.
oracle timestamp
oracle timestamp
asked Apr 18 '16 at 16:39
user27643user27643
1011
asked Apr 18 '16 at 16:39
user27643user27643
1011
edited May 10 '16 at 18:43
user27643
asked Apr 18 '16 at 16:39
user27643user27643
1011
asked Apr 18 '16 at 16:39
user27643user27643
1011
asked Apr 18 '16 at 16:39
user27643user27643
1011
1011
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You write "I don't need the time zone information", however datatype TIMESTAMP WITH LOCAL TIME ZONE has time zone information stored.
For a TIMESTAMP WITH LOCAL TIME ZONE column I don't see any difference between CURRENT_TIMESTAMP and LOCALTIMESTAMP either of them should work in the same way.
CURRENT_TIMESTAMP returns current data and time as of datatype TIMESTAMP WITH TIME ZONE, whereas LOCALTIMESTAMP returns a LOCALTIMESTAMP value. Both of them have to be implicitly converted to a TIMESTAMP WITH LOCAL TIME ZONE datatype.
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
add a comment |
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%2f135679%2flocaltimestamp-or-curent-timestamp-for-default-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You write "I don't need the time zone information", however datatype TIMESTAMP WITH LOCAL TIME ZONE has time zone information stored.
For a TIMESTAMP WITH LOCAL TIME ZONE column I don't see any difference between CURRENT_TIMESTAMP and LOCALTIMESTAMP either of them should work in the same way.
CURRENT_TIMESTAMP returns current data and time as of datatype TIMESTAMP WITH TIME ZONE, whereas LOCALTIMESTAMP returns a LOCALTIMESTAMP value. Both of them have to be implicitly converted to a TIMESTAMP WITH LOCAL TIME ZONE datatype.
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
add a comment |
You write "I don't need the time zone information", however datatype TIMESTAMP WITH LOCAL TIME ZONE has time zone information stored.
For a TIMESTAMP WITH LOCAL TIME ZONE column I don't see any difference between CURRENT_TIMESTAMP and LOCALTIMESTAMP either of them should work in the same way.
CURRENT_TIMESTAMP returns current data and time as of datatype TIMESTAMP WITH TIME ZONE, whereas LOCALTIMESTAMP returns a LOCALTIMESTAMP value. Both of them have to be implicitly converted to a TIMESTAMP WITH LOCAL TIME ZONE datatype.
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
add a comment |
You write "I don't need the time zone information", however datatype TIMESTAMP WITH LOCAL TIME ZONE has time zone information stored.
For a TIMESTAMP WITH LOCAL TIME ZONE column I don't see any difference between CURRENT_TIMESTAMP and LOCALTIMESTAMP either of them should work in the same way.
CURRENT_TIMESTAMP returns current data and time as of datatype TIMESTAMP WITH TIME ZONE, whereas LOCALTIMESTAMP returns a LOCALTIMESTAMP value. Both of them have to be implicitly converted to a TIMESTAMP WITH LOCAL TIME ZONE datatype.
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
You write "I don't need the time zone information", however datatype TIMESTAMP WITH LOCAL TIME ZONE has time zone information stored.
For a TIMESTAMP WITH LOCAL TIME ZONE column I don't see any difference between CURRENT_TIMESTAMP and LOCALTIMESTAMP either of them should work in the same way.
CURRENT_TIMESTAMP returns current data and time as of datatype TIMESTAMP WITH TIME ZONE, whereas LOCALTIMESTAMP returns a LOCALTIMESTAMP value. Both of them have to be implicitly converted to a TIMESTAMP WITH LOCAL TIME ZONE datatype.
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
answered Apr 23 '16 at 21:36
Wernfried DomscheitWernfried Domscheit
1,242612
1,242612
add a comment |
add a comment |
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%2f135679%2flocaltimestamp-or-curent-timestamp-for-default-value%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
