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:<\/p>\n
\nSSIS: What’s the difference between DT_DATE and DT_DBTIMESTAMP <\/h6>\n
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!!<\/p>\n<\/blockquote>\n
SSIS Junkie : SSIS: What’s the difference between DT_DATE and DT_DBTIMESTAMP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
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… Continue reading Processing the date can be a pain…<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17,32],"tags":[],"class_list":["post-56","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-sql","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-U","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/56","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=56"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/56\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=56"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=56"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=56"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}