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

Do you need to store values in the LOCAL time line (use TIMESTAMP), or WORLD time line (use TIMESTAMP WITH TIME ZONE)? — The Impaler
– The Impaler, Commented Mar 21, 2020 at 17:54
"that's a timestamp instead of datetime" makes no sense. Those two are literally the same thing — user330315
– user330315, Commented Mar 21, 2020 at 18:23

The Impaler · Accepted Answer · 2020-03-25 00:18:18Z

15

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.

edited Mar 25, 2020 at 0:18

answered Mar 21, 2020 at 18:12

The Impaler

49.3k10 gold badges50 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related