CODEWITHSUNDEEP
sqlpostgresql
JamesWang
JamesWang

Reputation: 1545

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

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

Upvotes: 8

Views: 10497

Answers (1)

The Impaler
The Impaler

Reputation: 48850

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.

Upvotes: 14

Related Questions