SQL current_timestamp+14

December 6, 2022

Hi I am having problem creating a table.
Here’s what I am trying to do:
I have a table that automatically inserts current time and a current time + 14 days.

Below is my code:

'''
create table borrowedbook (
studentEmail varchar(255) not null,
bookId varchar(255) not null,
borrowedDate datetime NOT NULL DEFAULT  current_timestamp(),
returnedDate datetime,
dueDate datetime NOT null default current_timestamp()+14,

FOREIGN KEY (studentEmail) REFERENCES student(studentEmail),
FOREIGN KEY (bookId) REFERENCES book(bookId)
);
'''

I need to make dueDate field work.

need help!

edit: I am using DBeaver, mysql

>Solution :

You can use date_add(time_stamp, interval):

create table borrowedbook (
studentEmail varchar(255) not null,
bookId varchar(255) not null,
borrowedDate datetime NOT NULL DEFAULT  current_timestamp(),
returnedDate datetime,

dueDate datetime NOT null default DATE_ADD(current_timestamp, INTERVAL 14 DAY),

FOREIGN KEY (studentEmail) REFERENCES student(studentEmail),
FOREIGN KEY (bookId) REFERENCES book(bookId)
);