{"id":1551,"date":"2016-01-27T13:12:50","date_gmt":"2016-01-27T11:12:50","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1551"},"modified":"2016-04-27T13:15:08","modified_gmt":"2016-04-27T10:15:08","slug":"logo-zaman-bilgisinin-logo-veritabanina-integer-olarak-aktarilmasi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-zaman-bilgisinin-logo-veritabanina-integer-olarak-aktarilmasi\/","title":{"rendered":"Logo Zaman bilgisinin Logo veritaban\u0131na integer olarak aktar\u0131lmas\u0131"},"content":{"rendered":"<p>Logo&#8217;da \u00a0zaman bilgisi baz\u0131 tablolarda integer alanlarda tutulmaktad\u0131r. Bu alanlar\u0131 doldurmak i\u00e7in a\u015fa\u011f\u0131daki SQL fonksiyonunu kullanabilirsiniz. (Veya ayn\u0131 kodu C# veya Delphi gibi yaz\u0131l\u0131m tool&#8217;lar\u0131nda haz\u0131rlayabilirsiniz)<\/p>\n<p>CREATE FUNCTION [<span class=\"hljs-link_label\">dbo<\/span>].[<span class=\"hljs-link_label\">LG_TIMETOINT<\/span>](<span class=\"hljs-link_url\">@HH INT,@MM INT,@SS INT<\/span>)<br \/>\nRETURNS INT<br \/>\nAS<br \/>\nBEGIN<br \/>\nDECLARE @TIME\u00a0 \u00a0 INT<br \/>\nSELECT @TIME\u00a0 \u00a0= (@HH<span class=\"hljs-emphasis\">*65536*<\/span>256+@MM<span class=\"hljs-emphasis\">*65536+@SS*<\/span>256)<br \/>\nRETURN(@TIME)<br \/>\nEND<\/p>\n<hr \/>\n<p><span class=\"bbc_color\">\u00d6rnek Kod:<\/span><\/p>\n<p>&#8212; \u00d6rne\u011fin saat 15:54:00 oldu\u011funda sonu\u00e7 integer olarak\u00a0 255197184 gelir<br \/>\nselect [dbo].[LG_TIMETOINT](15,54,00) as IntegerSaat<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Logo&#8217;da \u00a0zaman bilgisi baz\u0131 tablolarda integer alanlarda tutulmaktad\u0131r. Bu alanlar\u0131 doldurmak i\u00e7in a\u015fa\u011f\u0131daki SQL fonksiyonunu kullanabilirsiniz. (Veya ayn\u0131 kodu C# veya Delphi gibi yaz\u0131l\u0131m tool&#8217;lar\u0131nda haz\u0131rlayabilirsiniz) CREATE FUNCTION [dbo].[LG_TIMETOINT](@HH INT,@MM INT,@SS INT) RETURNS INT AS BEGIN DECLARE @TIME\u00a0 \u00a0 INT SELECT @TIME\u00a0 \u00a0= (@HH*65536*256+@MM*65536+@SS*256) RETURN(@TIME) END \u00d6rnek Kod: &#8212; \u00d6rne\u011fin saat 15:54:00 oldu\u011funda sonu\u00e7 integer [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,10],"tags":[],"class_list":["post-1551","post","type-post","status-publish","format-standard","hentry","category-logorapor","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1551"}],"version-history":[{"count":3,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1551\/revisions"}],"predecessor-version":[{"id":1554,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1551\/revisions\/1554"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}