Bug fix: the `timestamp` function should convert to a `datetime` type

[fulghum]

MySQL's timestamp function, despite its name, actually returns a datetime type and not a timestamp type.

MySQL example:

mysql -uroot --protocol TCP -e "select timestamp('1000-01-01 00:00:00');" --column-type-info
Field   1:  `timestamp('1000-01-01 00:00:00')`
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       DATETIME
Collation:  binary (63)
Length:     19
Max_length: 19
Decimals:   0
Flags:      BINARY 

+----------------------------------+
| timestamp('1000-01-01 00:00:00') |
+----------------------------------+
| 1000-01-01 00:00:00              |
+----------------------------------+

Note: We still need to add support for the second, optional parameter to timestamp().

Customer issue: https://github.com/dolthub/dolt/issues/8236

[timsehn]

This is some MySQL garbage.

[fulghum]

This is some MySQL garbage.

Yeah, MySQL has some wacky naming in several places 🤷‍♂️