In Pike 8.1 I checked in a few new native Sql types. This allows for faster, easier and lossless manipulation of dates/times/intervals. It also facilitates binary transfer to and from the database.
I currently implemented all this for the pgsql driver. The new code still needs documentation. Reviews welcome.