{"id":1357,"date":"2018-10-04T13:35:03","date_gmt":"2018-10-04T11:35:03","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1357"},"modified":"2018-10-04T13:35:03","modified_gmt":"2018-10-04T11:35:03","slug":"sql-jak-sprawdzic-precyzje-danych-w-kolumnie-number","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1357","title":{"rendered":"SQL &#8211; Jak sprawdzi\u0107 precyzje danych w kolumnie number"},"content":{"rendered":"<p>Czasami trzeba sprawdzi\u0107 jaka jest precyzja danych w kolumnie number. Mo\u017cna to sprawdzi\u0107<\/p>\n<pre lang='SQL'>\r\nSELECT\r\n    length(MAX(abs(trunc(assigned_qty,0) ) ) ) maxleftofdecimal,\r\n    MAX(length(mod(assigned_qty,1) ) ) - 1 maxrightofdecimal\r\nFROM\r\n    tmp1\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Czasami trzeba sprawdzi\u0107 jaka jest precyzja danych w kolumnie number. Mo\u017cna to sprawdzi\u0107 SELECT length(MAX(abs(trunc(assigned_qty,0) ) ) ) maxleftofdecimal, MAX(length(mod(assigned_qty,1) ) ) &#8211; 1 maxrightofdecimal FROM tmp1<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[186],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1357"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1357"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1357\/revisions"}],"predecessor-version":[{"id":1358,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1357\/revisions\/1358"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}