{"id":2024,"date":"2017-01-06T12:09:38","date_gmt":"2017-01-06T09:09:38","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=2024"},"modified":"2017-01-06T12:09:38","modified_gmt":"2017-01-06T09:09:38","slug":"sql-server-para-formati","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-server-para-formati\/","title":{"rendered":"SQL Server Para Format\u0131"},"content":{"rendered":"

T-SQL k\u00fct\u00fcphanesinde i\u00e7erisinde say\u0131sal bir veriyi yerel para format\u0131nda g\u00f6sterecek bir fonksiyon bulunmamaktad\u0131r. Ancak parasal de\u011fer MONEY format\u0131nda saklanm\u0131\u015fsa bu de\u011feri Management Studio \u00fczerinde SELECT etti\u011fimizde ondal\u0131k ayra\u00e7 (decimal symbol) bilgisini sunucudaki \u201cRegion and Language\u201d alan\u0131ndan okuyarak d\u00fczenleyebilir.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
DECLARE<\/code> @X MONEY<\/code><\/div>\n
DECLARE<\/code> @Y <\/code>NUMERIC<\/code>(9,2)<\/code><\/div>\n
SET<\/code> @X=125075.25<\/code><\/div>\n
SET<\/code> @Y=125075.25<\/code><\/div>\n
SELECT<\/code> @X<\/code><\/div>\n
SELECT<\/code> @Y<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Bu sorgunun sonucu s\u0131ras\u0131yla a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir.
\n125075,25
\n125075.25<\/i>
\nG\u00f6r\u00fcld\u00fc\u011f\u00fc gibi MONEY t\u00fcr\u00fcndeki veri i\u00e7in ondal\u0131k ayra\u00e7 olarak virg\u00fcl\u00fc kulland\u0131. Ayr\u0131ca veri t\u00fcr\u00fc MONEY oldu\u011fu zaman virg\u00fcl ve nokta ayra\u00e7lar\u0131 sorun \u00e7\u0131karmadan \u00e7evrilebilir. A\u015fa\u011f\u0131daki iki ifade de \u201c125075,25\u00a8 de\u011feri d\u00f6ner.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
SELECT<\/code> CAST<\/code>(<\/code>'125075.25'<\/code> as<\/code> MONEY)<\/code><\/div>\n
SELECT<\/code> CAST<\/code>(<\/code>'125,075.25'<\/code> as<\/code> MONEY)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

De\u011feri g\u00f6sterirken binlik ayra\u00e7 (digit grouping) bilgisini de g\u00f6stermek i\u00e7in CONVERT()<\/b>fonksiyonu kullan\u0131l\u0131r. CONVERT fonksiyonuna 3. parametre 1 de\u011feri verildi\u011fi zaman binlik ayra\u00e7\u0131 da g\u00f6stermi\u015f olacakt\u0131r.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
SELECT<\/code> CONVERT<\/code>(<\/code>VARCHAR<\/code>(10), @X, 1)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

125,075.25
\nCONVERT fonksiyonu sadece MONEY t\u00fcr\u00fcndeki veriler i\u00e7in bu \u015fekilde formatlama yapabilir. De\u011ferin t\u00fcr\u00fc MONEY de\u011filse \u00f6nce MONEY t\u00fcr\u00fcne \u00e7evirmek gerekecek.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
SELECT<\/code> CONVERT<\/code>(<\/code>VARCHAR<\/code>(10), <\/code>CAST<\/code>(125075.25 <\/code>as<\/code> MONEY), 1)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

T-SQL k\u00fct\u00fcphanesinde i\u00e7erisinde say\u0131sal bir veriyi yerel para format\u0131nda g\u00f6sterecek bir fonksiyon bulunmamaktad\u0131r. Ancak parasal de\u011fer MONEY format\u0131nda saklanm\u0131\u015fsa bu de\u011feri Management Studio \u00fczerinde SELECT etti\u011fimizde ondal\u0131k ayra\u00e7 (decimal symbol) bilgisini sunucudaki \u201cRegion and Language\u201d alan\u0131ndan okuyarak d\u00fczenleyebilir. 1 2 3 4 5 6 DECLARE @X MONEY DECLARE @Y NUMERIC(9,2) SET @X=125075.25 SET @Y=125075.25 SELECT […]<\/p>\n","protected":false},"author":4,"featured_media":1588,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-2024","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2024","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=2024"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2024\/revisions"}],"predecessor-version":[{"id":2025,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2024\/revisions\/2025"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1588"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=2024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}