tag:blogger.com,1999:blog-38925478102379929262011-11-28T01:22:38.078+02:00Journeys through software development by Dincer UyavDincer Uyavhttp://www.blogger.com/profile/16034099023984489401noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3892547810237992926.post-17756353294079543542009-12-18T11:36:00.002+02:002009-12-18T11:45:15.948+02:002009-12-18T11:45:15.948+02:00 <p><a href="http://feedads.g.doubleclick.net/~a/gxX5YZDu5yBT1KJF3kyL7NacXxw/0/da"><img src="http://feedads.g.doubleclick.net/~a/gxX5YZDu5yBT1KJF3kyL7NacXxw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/gxX5YZDu5yBT1KJF3kyL7NacXxw/1/da"><img src="http://feedads.g.doubleclick.net/~a/gxX5YZDu5yBT1KJF3kyL7NacXxw/1/di" border="0" ismap="true"></img></a></p><div style="text-align: justify;">Özellikle raporlamada ihtiyaç duyduğum birşey tarihden saati çıkarmak. Ben genelde alttakileri kullanıyorum SQL Server'da, başka bir yöntemi olan varsa: bizimle paylaşırsa sevinirim.<br /> </div><br /> <pre class="brush: sql">SELECT CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME) SELECT dateadd(d, 0, datediff(d, 0, getdate())) </pre><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3892547810237992926-1775635329407954354?l=dinceru.blogspot.com' alt='' /></div><img src="http://feeds.feedburner.com/~r/DincersWeblog/~4/nlRoY_patsw" height="1" width="1"/>Dincer Uyavhttp://www.blogger.com/profile/16034099023984489401noreply@blogger.com0http://dinceru.blogspot.com/2009/12/tsql-de-tarihten-saati-ckarmak.html