feat(pgproto): support datetime values

Summary

• feat(pgproto): support datetime values

---

• Close #618 (closed), #626 (closed), #627 (closed)
• Cherry-pick to: none / 24.4 / 24.3 / 24.2
• Docs follow-up: not necessary / new issue