postgresql - datetime: does postgresql have datetime type like in mysql?

Question

I know in mysql there is datetime type but couldn't find couterpart in postgresql. I know there is timestamp type in postgresql but that's a timestamp instead of datetime.

Thanks

Answer 1

A MySQL DATETIME is equivalent to a PostgreSQL TIMESTAMP.

Both store a date+time value in an undefined time line. They assume the time offset or time zone is of no interest, or is defined by the application.