{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/763","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/763/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/763/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/763/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/763","id":174800553,"number":763,"title":"NET / Windows DateTime type","user":{"login":"Plutonix","id":12514284,"avatar_url":"https://avatars.githubusercontent.com/u/12514284?v=3","gravatar_id":"","url":"https://api.github.com/users/Plutonix","html_url":"https://github.com/Plutonix","followers_url":"https://api.github.com/users/Plutonix/followers","following_url":"https://api.github.com/users/Plutonix/following{/other_user}","gists_url":"https://api.github.com/users/Plutonix/gists{/gist_id}","starred_url":"https://api.github.com/users/Plutonix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Plutonix/subscriptions","organizations_url":"https://api.github.com/users/Plutonix/orgs","repos_url":"https://api.github.com/users/Plutonix/repos","events_url":"https://api.github.com/users/Plutonix/events{/privacy}","received_events_url":"https://api.github.com/users/Plutonix/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-09-02T16:36:29Z","updated_at":"2016-09-06T21:17:22Z","closed_at":null,"body":"### Details for the issue\r\n\r\nThis is more a feature request/suggestion and is specific to .NET\r\n\r\nIf you define a column as 'DATETIME', the (\"official\") .NET DB provider objects can be configured to return actual .NET DateTime Types via SQLiteDataAdapter and SQLiteDataReader.\r\n\r\nThe \"issue\" is that DB Browser tends to ignore/discard \"DateTime\" and use INTEGER (or sometimes the last legal base type selected).  The only way is to use a CREATE TABLE statement in a SQL window.  Once the table is created, 'DateTime' shows in the column type list but **only** for those columns already defined that way.\r\n\r\nThis would likely be confusing for other platforms, so it might be useful to display 'NetDate` or similar to the user but use 'DateTime' in the CREATE statement.  Another option would be to enable it via a Preference.\r\n\r\n\r\n### Useful extra information\r\n\r\n\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [ ] DB4S has a bug\r\n- [x] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [x] Windows\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [ ] 3.9.0\r\n- [x] 3.8.0\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [ ] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows\r\n- [ ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/245094662","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/763#issuecomment-245094662","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/763","id":245094662,"user":{"login":"Plutonix","id":12514284,"avatar_url":"https://avatars.githubusercontent.com/u/12514284?v=3","gravatar_id":"","url":"https://api.github.com/users/Plutonix","html_url":"https://github.com/Plutonix","followers_url":"https://api.github.com/users/Plutonix/followers","following_url":"https://api.github.com/users/Plutonix/following{/other_user}","gists_url":"https://api.github.com/users/Plutonix/gists{/gist_id}","starred_url":"https://api.github.com/users/Plutonix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Plutonix/subscriptions","organizations_url":"https://api.github.com/users/Plutonix/orgs","repos_url":"https://api.github.com/users/Plutonix/repos","events_url":"https://api.github.com/users/Plutonix/events{/privacy}","received_events_url":"https://api.github.com/users/Plutonix/received_events","type":"User","site_admin":false},"created_at":"2016-09-06T21:17:22Z","updated_at":"2016-09-06T21:17:22Z","body":"I think using something from the list is generally a good idea, since the list is complete except for this one (?) case.   There might be other types allowed - who knows,  I cant find this latent ability documented anywhere.  \r\n\r\nSince other platforms might choke on it, is the reason I suggested an option.  When *Enable NET DateTime* is on, add DateTime and Date to the list (I am not sure it actually treats Date differently).\r\n\r\nHere is a reason this could be very valuable:  if you execute a CREATE TABLE statement from your NET app, Type Affinity apparently kicks in and also changes* DATETIME* to *TEXT*.  That means for NET devs they **need some sort of tool** like this to create tables that support DATETIME types.  The Execute SQL tab works perfectly."}}
{"actor":{"display_login":"Plutonix"}}