postgresql datetype question

[colap]

Which is valid/better data type for date in postgresql table?

Is it date or datetime ?

 

create table dd ( id serial primary key, title varchar(50) not null, created_at date);

[btherl]

date is fine for storing dates without the time of day.  timestamp stores date and time, something like datetime in mysql I believe.  Timestamp can be with timezone or without timezone.