Save only the current time in a column - MySQL
0
I have this table and I want to save in my column hora_inicio_uso only the current time
CREATE TABLE prestamo_usuarios(
matricula_alumno VARCHAR(255),
id_equipo INT,
fecha_prestamo DATE,
fecha_devolucion DATE,
hora_inicio_uso DATE,
hora_fin_uso DATE,
id_prestamo INT
);
I insert data into this table through a procedure
DELIMITER |
CREATE PROCEDURE RealizarPrestamoEquipo (IN matricula_param VARCHAR(255), IN equipo_param INT(11), IN id_prestamo_param INT(11))
BEGIN
INSERT INTO prestamo_usuarios
(matricula_alumno, id_equipo, fecha_prestamo, hora_inicio_uso, id_prestamo)
VALUES
(matricula_param, equipo_param, CURDATE(), CURTIME(), id_prestamo_param);
END
|
DELIMITER ;
I tried to solve this with the CURTIME() function, but this only saves the current date where I should keep the time, some idea of how I can do this?
mysql
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
add a comment |
0
I have this table and I want to save in my column hora_inicio_uso only the current time
CREATE TABLE prestamo_usuarios(
matricula_alumno VARCHAR(255),
id_equipo INT,
fecha_prestamo DATE,
fecha_devolucion DATE,
hora_inicio_uso DATE,
hora_fin_uso DATE,
id_prestamo INT
);
I insert data into this table through a procedure
DELIMITER |
CREATE PROCEDURE RealizarPrestamoEquipo (IN matricula_param VARCHAR(255), IN equipo_param INT(11), IN id_prestamo_param INT(11))
BEGIN
INSERT INTO prestamo_usuarios
(matricula_alumno, id_equipo, fecha_prestamo, hora_inicio_uso, id_prestamo)
VALUES
(matricula_param, equipo_param, CURDATE(), CURTIME(), id_prestamo_param);
END
|
DELIMITER ;
I tried to solve this with the CURTIME() function, but this only saves the current date where I should keep the time, some idea of how I can do this?
mysql
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
2
hora_inicio_usois defined asDATEtype. Define it asTimeinstead
– Madhur Bhaiya
Nov 28 '18 at 5:10
1
But save yourself from future troubles by simply defining a singleDATETIMEcolumn instead and storeNOW()instead of two separate columns for date and time
– Madhur Bhaiya
Nov 28 '18 at 5:11
@MadhurBhaiya How can I edit only the time?
– AlexCs
Nov 28 '18 at 5:16
Single DATETIME column is always better. If you really want two columns, you can create a VIEW from the parent table which has date and time.
– Anirudh
Nov 28 '18 at 5:17
How can I edit only the time? first define the column's data type asTime(not Date as you currently have it) but at some point in the future you may wish you had both date and time as a single value.
– Used_By_Already
Nov 28 '18 at 6:05
add a comment |
0
0
0
I have this table and I want to save in my column hora_inicio_uso only the current time
CREATE TABLE prestamo_usuarios(
matricula_alumno VARCHAR(255),
id_equipo INT,
fecha_prestamo DATE,
fecha_devolucion DATE,
hora_inicio_uso DATE,
hora_fin_uso DATE,
id_prestamo INT
);
I insert data into this table through a procedure
DELIMITER |
CREATE PROCEDURE RealizarPrestamoEquipo (IN matricula_param VARCHAR(255), IN equipo_param INT(11), IN id_prestamo_param INT(11))
BEGIN
INSERT INTO prestamo_usuarios
(matricula_alumno, id_equipo, fecha_prestamo, hora_inicio_uso, id_prestamo)
VALUES
(matricula_param, equipo_param, CURDATE(), CURTIME(), id_prestamo_param);
END
|
DELIMITER ;
I tried to solve this with the CURTIME() function, but this only saves the current date where I should keep the time, some idea of how I can do this?
mysql
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
I have this table and I want to save in my column hora_inicio_uso only the current time
CREATE TABLE prestamo_usuarios(
matricula_alumno VARCHAR(255),
id_equipo INT,
fecha_prestamo DATE,
fecha_devolucion DATE,
hora_inicio_uso DATE,
hora_fin_uso DATE,
id_prestamo INT
);
I insert data into this table through a procedure
DELIMITER |
CREATE PROCEDURE RealizarPrestamoEquipo (IN matricula_param VARCHAR(255), IN equipo_param INT(11), IN id_prestamo_param INT(11))
BEGIN
INSERT INTO prestamo_usuarios
(matricula_alumno, id_equipo, fecha_prestamo, hora_inicio_uso, id_prestamo)
VALUES
(matricula_param, equipo_param, CURDATE(), CURTIME(), id_prestamo_param);
END
|
DELIMITER ;
I tried to solve this with the CURTIME() function, but this only saves the current date where I should keep the time, some idea of how I can do this?
mysql
mysql
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
asked Nov 28 '18 at 5:09
AlexCsAlexCs
356
356
2
hora_inicio_usois defined asDATEtype. Define it asTimeinstead
– Madhur Bhaiya
Nov 28 '18 at 5:10
1
But save yourself from future troubles by simply defining a singleDATETIMEcolumn instead and storeNOW()instead of two separate columns for date and time
– Madhur Bhaiya
Nov 28 '18 at 5:11
@MadhurBhaiya How can I edit only the time?
– AlexCs
Nov 28 '18 at 5:16
Single DATETIME column is always better. If you really want two columns, you can create a VIEW from the parent table which has date and time.
– Anirudh
Nov 28 '18 at 5:17
How can I edit only the time? first define the column's data type asTime(not Date as you currently have it) but at some point in the future you may wish you had both date and time as a single value.
– Used_By_Already
Nov 28 '18 at 6:05
add a comment |
2
hora_inicio_usois defined asDATEtype. Define it asTimeinstead
– Madhur Bhaiya
Nov 28 '18 at 5:10
1
But save yourself from future troubles by simply defining a singleDATETIMEcolumn instead and storeNOW()instead of two separate columns for date and time
– Madhur Bhaiya
Nov 28 '18 at 5:11
@MadhurBhaiya How can I edit only the time?
– AlexCs
Nov 28 '18 at 5:16
Single DATETIME column is always better. If you really want two columns, you can create a VIEW from the parent table which has date and time.
– Anirudh
Nov 28 '18 at 5:17
How can I edit only the time? first define the column's data type asTime(not Date as you currently have it) but at some point in the future you may wish you had both date and time as a single value.
– Used_By_Already
Nov 28 '18 at 6:05
2
2
hora_inicio_uso is defined as DATE type. Define it as Time instead– Madhur Bhaiya
Nov 28 '18 at 5:10
hora_inicio_uso is defined as DATE type. Define it as Time instead– Madhur Bhaiya
Nov 28 '18 at 5:10
1
1
But save yourself from future troubles by simply defining a single
DATETIME column instead and store NOW() instead of two separate columns for date and time– Madhur Bhaiya
Nov 28 '18 at 5:11
But save yourself from future troubles by simply defining a single
DATETIME column instead and store NOW() instead of two separate columns for date and time– Madhur Bhaiya
Nov 28 '18 at 5:11
@MadhurBhaiya How can I edit only the time?
– AlexCs
Nov 28 '18 at 5:16
@MadhurBhaiya How can I edit only the time?
– AlexCs
Nov 28 '18 at 5:16
Single DATETIME column is always better. If you really want two columns, you can create a VIEW from the parent table which has date and time.
– Anirudh
Nov 28 '18 at 5:17
Single DATETIME column is always better. If you really want two columns, you can create a VIEW from the parent table which has date and time.
– Anirudh
Nov 28 '18 at 5:17
How can I edit only the time? first define the column's data type as
Time (not Date as you currently have it) but at some point in the future you may wish you had both date and time as a single value.– Used_By_Already
Nov 28 '18 at 6:05
How can I edit only the time? first define the column's data type as
Time (not Date as you currently have it) but at some point in the future you may wish you had both date and time as a single value.– Used_By_Already
Nov 28 '18 at 6:05
add a comment |
0
active
oldest
votes
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',
autoActivateHeartbeat: false,
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');
});
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%2fstackoverflow.com%2fquestions%2f53512521%2fsave-only-the-current-time-in-a-column-mysql%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
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53512521%2fsave-only-the-current-time-in-a-column-mysql%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
2
hora_inicio_usois defined asDATEtype. Define it asTimeinstead– Madhur Bhaiya
Nov 28 '18 at 5:10
1
But save yourself from future troubles by simply defining a single
DATETIMEcolumn instead and storeNOW()instead of two separate columns for date and time– Madhur Bhaiya
Nov 28 '18 at 5:11
@MadhurBhaiya How can I edit only the time?
– AlexCs
Nov 28 '18 at 5:16
Single DATETIME column is always better. If you really want two columns, you can create a VIEW from the parent table which has date and time.
– Anirudh
Nov 28 '18 at 5:17
How can I edit only the time? first define the column's data type as
Time(not Date as you currently have it) but at some point in the future you may wish you had both date and time as a single value.– Used_By_Already
Nov 28 '18 at 6:05