23 Ocak 2017 Pazartesi

SQL QUERY - GET TODAY'S DATE



DECLARE @FistDate DATETIME = (SELECT DATEADD(m, DATEDIFF(m,0,GETDATE()),0))
DECLARE @TODAY DATETIME = (SELECT GETDATE())

SELECT DATEADD(day, 1, GETDATE()), DATEADD(day, DATEDIFF(day,0,GETDATE()),0), @FistDate,@TODAY


seklinde cikti aliriz.



SELECT DATEADD(m, DATEDIFF(m,0,GETDATE()),0) + ' ' + (select convert(varchar(10), GETDATE(), 108))

ayin ilk gunu ile su an ki zamani birlestirme