Create SQL table using full DATE

Asked Jun 14 '17 at 08:17

Active Jun 14 '17 at 08:20

Viewed 33 times

I'm currently creating a database and I'm facing a little issue. I want to add a column containing the date. So I create it like this :

create table comments
(
    id serial not null,
    id_user integer not null,
    content text not null,
    id_thread integer not null,
    date date default now()
);

The problem is that the date is just like this : 14-06-2017 and I want to have the hour of the creation.

How I can do that ?

Thanks in advance

asked Jun 14 '17 at 08:17

Nathan30

`date datetime default now()` – RiggsFolly Jun 14 '17 at 08:20
Consider using `datetime` or `timestamp` instead of plain `date`. – Tim Biegeleisen Jun 14 '17 at 08:20
use datetime. `date datetime default now()` – marmeladze Jun 14 '17 at 08:20
Also consider renaming attribute `date`, date is a reserved keyword, things are easier if you name it differently. – HoneyBadger Jun 14 '17 at 08:21
Perfect, thanks a lot :) – Nathan30 Jun 14 '17 at 08:44

Create SQL table using full DATE

0 Answers0