{"action":"created","issue":{"url":"https://api.github.com/repos/schambers/fluentmigrator/issues/573","labels_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/573/labels{/name}","comments_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/573/comments","events_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/573/events","html_url":"https://github.com/schambers/fluentmigrator/pull/573","id":55858932,"number":573,"title":"Provides an ability to create a column and specify that the timezone information should be stored with the date","user":{"login":"dealproc","id":1635244,"avatar_url":"https://avatars.githubusercontent.com/u/1635244?v=3","gravatar_id":"","url":"https://api.github.com/users/dealproc","html_url":"https://github.com/dealproc","followers_url":"https://api.github.com/users/dealproc/followers","following_url":"https://api.github.com/users/dealproc/following{/other_user}","gists_url":"https://api.github.com/users/dealproc/gists{/gist_id}","starred_url":"https://api.github.com/users/dealproc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dealproc/subscriptions","organizations_url":"https://api.github.com/users/dealproc/orgs","repos_url":"https://api.github.com/users/dealproc/repos","events_url":"https://api.github.com/users/dealproc/events{/privacy}","received_events_url":"https://api.github.com/users/dealproc/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/schambers/fluentmigrator/labels/Improvement","name":"Improvement","color":"0b02e1"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/schambers/fluentmigrator/milestones/16","labels_url":"https://api.github.com/repos/schambers/fluentmigrator/milestones/16/labels","id":915664,"number":16,"title":"vNext","description":"","creator":{"login":"tommarien","id":1032545,"avatar_url":"https://avatars.githubusercontent.com/u/1032545?v=3","gravatar_id":"","url":"https://api.github.com/users/tommarien","html_url":"https://github.com/tommarien","followers_url":"https://api.github.com/users/tommarien/followers","following_url":"https://api.github.com/users/tommarien/following{/other_user}","gists_url":"https://api.github.com/users/tommarien/gists{/gist_id}","starred_url":"https://api.github.com/users/tommarien/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tommarien/subscriptions","organizations_url":"https://api.github.com/users/tommarien/orgs","repos_url":"https://api.github.com/users/tommarien/repos","events_url":"https://api.github.com/users/tommarien/events{/privacy}","received_events_url":"https://api.github.com/users/tommarien/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":4,"state":"open","created_at":"2014-12-27T12:32:48Z","updated_at":"2015-02-05T11:55:11Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-01-29T05:42:37Z","updated_at":"2015-02-06T09:32:00Z","closed_at":"2015-02-05T11:55:11Z","pull_request":{"url":"https://api.github.com/repos/schambers/fluentmigrator/pulls/573","html_url":"https://github.com/schambers/fluentmigrator/pull/573","diff_url":"https://github.com/schambers/fluentmigrator/pull/573.diff","patch_url":"https://github.com/schambers/fluentmigrator/pull/573.patch"},"body":"Provides the ability to store timezone information for a given date within the database.\r\n\r\nC# syntax would be:\r\n`Create.Table(\"Table1\").WithColumn(\"CreatedOnUTC\").AsDateTimeOffset();`\r\n\r\nSql Server >= 2008 & Postgres implementations are in place already.\r\n\r\nI also added the `DbType.DateTime2` mapping to the `timestamp` type for postgres, as the `timestamp` time in postgres can hold a larger range of date/time values.\r\n"},"comment":{"url":"https://api.github.com/repos/schambers/fluentmigrator/issues/comments/73210107","html_url":"https://github.com/schambers/fluentmigrator/pull/573#issuecomment-73210107","issue_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/573","id":73210107,"user":{"login":"dealproc","id":1635244,"avatar_url":"https://avatars.githubusercontent.com/u/1635244?v=3","gravatar_id":"","url":"https://api.github.com/users/dealproc","html_url":"https://github.com/dealproc","followers_url":"https://api.github.com/users/dealproc/followers","following_url":"https://api.github.com/users/dealproc/following{/other_user}","gists_url":"https://api.github.com/users/dealproc/gists{/gist_id}","starred_url":"https://api.github.com/users/dealproc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dealproc/subscriptions","organizations_url":"https://api.github.com/users/dealproc/orgs","repos_url":"https://api.github.com/users/dealproc/repos","events_url":"https://api.github.com/users/dealproc/events{/privacy}","received_events_url":"https://api.github.com/users/dealproc/received_events","type":"User","site_admin":false},"created_at":"2015-02-06T09:32:00Z","updated_at":"2015-02-06T09:32:00Z","body":":+1: \r\nI hope I have the fix in there, can you double check..\r\n\r\nI've been using a custom build since i brought this up 18 months ago... there was an issue i unearthed when i re-worked this PR that if you run the `Insert.Into(\"Table\").Record(new { datetimeoffsetcolumn = DateTimeOffset.UTCNow })` statement, the date/time wasn't being quoted, and the insert statement would fail.  \r\n\r\nI know i corrected it in my working folder, but am unsure if you've received it as part of this PR or not.\r\n\r\nIf you can confirm... or otherwise, I'll see about providing that patch as well."}}