Processing the date can be a pain…

 I was trying to migrate a table from one database to another using a script.  It shouldn’t have been too complicated.  It probably wouldn’t be for someone who has done it before.  I had a problem getting some of the fields to copy over.  They all involved date/time information.  My search led me to this interesting post:

SSIS: What’s the difference between DT_DATE and DT_DBTIMESTAMP

Database people don’t generally like date values too much. They’re too fiddly. There’s god-knows-how-many ways of representing them…and don’t even get me started on regional date settings!!

SSIS Junkie : SSIS: What’s the difference between DT_DATE and DT_DBTIMESTAMP

Leave a comment

Your email address will not be published.