Building custom content type and 'howto' with Date fields

Hi.
I've read some tutorials about building a custom content type and i'm trying to build mine ( i know about cck but i just want to be able to duplicate this custom content type from site to site and not to rebuild it with cck everytime).
But i'm stuck with the date fields.As it seems and if i use the Date API module the fields ( table-fields ) have integer type
and not date-time etc.I dont want to ask if this is correct or not.But how can i be sure when i'm building a custom content type if this will work.I mean how can i be sure that after i upload my custom-module-content-type and activate the DATE API module etc.
this will be visible inside Views for example?
This is not only for the date fields but for other fields to for example a zip code ( there's already a cck expansion for this )
,addresses ( cck expansion 2 ) . . . how do i setup the correct field type ( integer,float,bigint etc ) inside mysql or via the schema module?
thanx!