{"id":194,"date":"2013-07-03T11:42:30","date_gmt":"2013-07-03T11:42:30","guid":{"rendered":"http:\/\/dijitalturk.com\/veysel\/?p=194"},"modified":"2013-07-03T12:06:06","modified_gmt":"2013-07-03T12:06:06","slug":"sql-date-time-conversion","status":"publish","type":"post","link":"https:\/\/dijitalturk.com\/veysel\/sql-date-time-conversion\/","title":{"rendered":"SQL Date Time conversion"},"content":{"rendered":"<p><strong>SQL Date Time\u00a0conversion \/ Tarih zaman d\u00f6n\u00fc\u015f\u00fcmleri<\/strong><\/p>\n<p>MSSQL &#8216;de \u00e7ok kulland\u0131\u011f\u0131m\u0131z d\u00f6n\u00fc\u015f\u00fcm d\u00f6n\u00fc\u015f\u00fcm kodlar\u0131 ve \u00f6rnekleri<\/p>\n<pre class=\"height-set:true lang:default decode:true crayon-selected\" title=\"SQL Date Time conversion\">SQL Server string to date \/ datetime conversion - datetime string format sql server\r\n\r\n-- MSSQL string to datetime conversion - convert char to date - convert varchar to date\r\n\r\n-- Subtract 100 from style number (format) for yy instead yyyy (or ccyy with century)\r\n\r\nSELECT convert(datetime, 'Oct 23 2012 11:01AM', 100) -- mon dd yyyy hh:mmAM (or PM)\r\n\r\nSELECT convert(datetime, 'Oct 23 2012 11:01AM') -- 2012-10-23 11:01:00.000\r\n\r\n-- Without century (yy) string date conversion - convert string to datetime function\r\n\r\nSELECT convert(datetime, 'Oct 23 12 11:01AM', 0) -- mon dd yy hh:mmAM (or PM)\r\n\r\nSELECT convert(datetime, 'Oct 23 12 11:01AM') -- 2012-10-23 11:01:00.000\r\n\r\n-- Convert string to datetime sql - convert string to date sql - sql dates format\r\n\r\n-- T-SQL convert string to datetime - SQL Server convert string to date\r\n\r\nSELECT convert(datetime, '10\/23\/2016', 101) -- mm\/dd\/yyyy\r\n\r\nSELECT convert(datetime, '2016.10.23', 102) -- yyyy.mm.dd ANSI date with century\r\n\r\nSELECT convert(datetime, '23\/10\/2016', 103) -- dd\/mm\/yyyy\r\n\r\nSELECT convert(datetime, '23.10.2016', 104) -- dd.mm.yyyy\r\n\r\nSELECT convert(datetime, '23-10-2016', 105) -- dd-mm-yyyy\r\n\r\n-- mon types are nondeterministic conversions, dependent on language setting\r\n\r\nSELECT convert(datetime, '23 OCT 2016', 106) -- dd mon yyyy\r\n\r\nSELECT convert(datetime, 'Oct 23, 2016', 107) -- mon dd, yyyy\r\n\r\n-- 2016-10-23 00:00:00.000\r\n\r\nSELECT convert(datetime, '20:10:44', 108) -- hh:mm:ss\r\n\r\n-- 1900-01-01 20:10:44.000\r\n\r\n-- mon dd yyyy hh:mm:ss:mmmAM (or PM) - sql time format - SQL Server datetime format\r\n\r\nSELECT convert(datetime, 'Oct 23 2016 11:02:44:013AM', 109)\r\n\r\n-- 2016-10-23 11:02:44.013\r\n\r\nSELECT convert(datetime, '10-23-2016', 110) -- mm-dd-yyyy\r\n\r\nSELECT convert(datetime, '2016\/10\/23', 111) -- yyyy\/mm\/dd\r\n\r\n-- YYYYMMDD ISO date format works at any language setting - international standard\r\n\r\nSELECT convert(datetime, '20161023')\r\n\r\nSELECT convert(datetime, '20161023', 112) -- ISO yyyymmdd\r\n\r\n-- 2016-10-23 00:00:00.000\r\n\r\nSELECT convert(datetime, '23 Oct 2016 11:02:07:577', 113) -- dd mon yyyy hh:mm:ss:mmm\r\n\r\n-- 2016-10-23 11:02:07.577\r\n\r\nSELECT convert(datetime, '20:10:25:300', 114) -- hh:mm:ss:mmm(24h)\r\n\r\n-- 1900-01-01 20:10:25.300\r\n\r\nSELECT convert(datetime, '2016-10-23 20:44:11', 120) -- yyyy-mm-dd hh:mm:ss(24h)\r\n\r\n-- 2016-10-23 20:44:11.000\r\n\r\nSELECT convert(datetime, '2016-10-23 20:44:11.500', 121) -- yyyy-mm-dd hh:mm:ss.mmm\r\n\r\n-- 2016-10-23 20:44:11.500\r\n\r\n-- Style 126 is ISO 8601 format: international standard - works with any language setting\r\n\r\nSELECT convert(datetime, '2008-10-23T18:52:47.513', 126) -- yyyy-mm-ddThh:mm:ss(.mmm)\r\n\r\n-- 2008-10-23 18:52:47.513\r\n\r\nSELECT convert(datetime, N'23 \u0634\u0648\u0627\u0644 1429  6:52:47:513PM', 130) -- Islamic\/Hijri date\r\n\r\nSELECT convert(datetime, '23\/10\/1429  6:52:47:513PM',    131) -- Islamic\/Hijri date\r\n\r\n-- Convert DDMMYYYY format to datetime - sql server to date \/ datetime\r\n\r\nSELECT convert(datetime, STUFF(STUFF('31012016',3,0,'-'),6,0,'-'), 105)\r\n\r\n-- 2016-01-31 00:00:00.000\r\n\r\n-- SQL Server T-SQL string to datetime conversion without century - some exceptions\r\n\r\n-- nondeterministic means language setting dependent such as Mar\/M\u00e4r\/mars\/m\u00e1rc\r\n\r\nSELECT convert(datetime, 'Oct 23 16 11:02:44AM') -- Default\r\n\r\nSELECT convert(datetime, '10\/23\/16', 1) -- mm\/dd\/yy U.S.\r\n\r\nSELECT convert(datetime, '16.10.23', 2) -- yy.mm.dd ANSI\r\n\r\nSELECT convert(datetime, '23\/10\/16', 3) -- dd\/mm\/yy UK\/FR\r\n\r\nSELECT convert(datetime, '23.10.16', 4) -- dd.mm.yy German\r\n\r\nSELECT convert(datetime, '23-10-16', 5) -- dd-mm-yy Italian\r\n\r\nSELECT convert(datetime, '23 OCT 16', 6) -- dd mon yy non-det.\r\n\r\nSELECT convert(datetime, 'Oct 23, 16', 7) -- mon dd, yy non-det.\r\n\r\nSELECT convert(datetime, '20:10:44', 8) -- hh:mm:ss\r\n\r\nSELECT convert(datetime, 'Oct 23 16 11:02:44:013AM', 9) -- Default with msec\r\n\r\nSELECT convert(datetime, '10-23-16', 10) -- mm-dd-yy U.S.\r\n\r\nSELECT convert(datetime, '16\/10\/23', 11) -- yy\/mm\/dd Japan\r\n\r\nSELECT convert(datetime, '161023', 12) -- yymmdd ISO\r\n\r\nSELECT convert(datetime, '23 Oct 16 11:02:07:577', 13) -- dd mon yy hh:mm:ss:mmm EU dflt\r\n\r\nSELECT convert(datetime, '20:10:25:300', 14) -- hh:mm:ss:mmm(24h)\r\n\r\nSELECT convert(datetime, '2016-10-23 20:44:11',20) -- yyyy-mm-dd hh:mm:ss(24h) ODBC can.\r\n\r\nSELECT convert(datetime, '2016-10-23 20:44:11.500', 21)-- yyyy-mm-dd hh:mm:ss.mmm ODBC\r\n\r\n------------\r\n\r\n-- SQL Datetime Data Type: Combine date &amp; time string into datetime - sql hh mm ss\r\n\r\n-- String to datetime - mssql datetime - sql convert date - sql concatenate string\r\n\r\nDECLARE @DateTimeValue varchar(32), @DateValue char(8), @TimeValue char(6)\r\n\r\nSELECT @DateValue = '20120718',\r\n\r\n@TimeValue = '211920'\r\n\r\nSELECT @DateTimeValue =\r\n\r\nconvert(varchar, convert(datetime, @DateValue), 111)\r\n\r\n+ ' ' + substring(@TimeValue, 1, 2)\r\n\r\n+ ':' + substring(@TimeValue, 3, 2)\r\n\r\n+ ':' + substring(@TimeValue, 5, 2)\r\n\r\nSELECT\r\n\r\nDateInput = @DateValue, TimeInput = @TimeValue,\r\n\r\nDateTimeOutput = @DateTimeValue;\r\n\r\n\/*\r\n\r\nDateInput   TimeInput   DateTimeOutput\r\n\r\n20120718    211920      2012\/07\/18 21:19:20 *\/\r\n\r\no 2nd 4 bytes: number of clock-ticks (3.33 milliseconds) since midnight\/* DATETIME 8 bytes internal storage structure\r\no 1st 4 bytes: number of days after the base date 1900-01-01\r\n\r\nDATE 3 bytes internal storage structure\r\no 3 bytes integer: number of days after the first date 0001-01-01\r\no Note: hex byte order reversed\r\n\r\nSMALLDATETIME 4 bytes internal storage structure\r\no 1st 2 bytes: number of days after the base date 1900-01-01\r\n\r\no 2nd 2 bytes: number of minutes since midnight   *\/\r\n\r\nSELECT CONVERT(binary(8), getdate()) -- 0x00009E4D 00C01272\r\n\r\nSELECT CONVERT(binary(4), convert(smalldatetime,getdate())) -- 0x9E4D 02BC\r\n\r\n-- This is how a datetime looks in 8 bytes\r\n\r\nDECLARE @dtHex binary(8)= 0x00009966002d3344;\r\n\r\nDECLARE @dt datetime = @dtHex\r\n\r\nSELECT @dt   -- 2007-07-09 02:44:34.147\r\n\r\n------------ *\/\r\n\r\n------------\r\n\r\n-- SQL Server 2012 New Date &amp; Time Related Functions\r\n\r\n------------\r\n\r\nSELECT DATEFROMPARTS ( 2016, 10, 23 ) AS RealDate; -- 2016-10-23\r\n\r\nSELECT DATETIMEFROMPARTS ( 2016, 10, 23, 10, 10, 10, 500 ) AS RealDateTime; -- 2016-10-23 10:10:10.500\r\n\r\nSELECT EOMONTH('20140201');       -- 2014-02-28\r\n\r\nSELECT EOMONTH('20160201');       -- 2016-02-29\r\n\r\nSELECT EOMONTH('20160201',1);     -- 2016-03-31\r\n\r\nSELECT FORMAT ( getdate(), 'yyyy\/MM\/dd hh:mm:ss tt', 'en-US' );   -- 2016\/07\/30 03:39:48 AM\r\n\r\nSELECT FORMAT ( getdate(), 'd', 'en-US' );                        -- 7\/30\/2016\r\n\r\nSELECT PARSE('SAT, 13 December 2014' AS datetime USING 'en-US') AS [Date&amp;Time];\r\n\r\n-- 2014-12-13 00:00:00.000\r\n\r\nSELECT TRY_PARSE('SAT, 13 December 2014' AS datetime USING 'en-US') AS [Date&amp;Time];\r\n\r\n-- 2014-12-13 00:00:00.000\r\n\r\nSELECT TRY_CONVERT(datetime, '13 December 2014' ) AS [Date&amp;Time];  -- 2014-12-13 00:00:00.000\r\n\r\n------------\r\n\r\n-- SQL convert seconds to HH:MM:SS - sql times format - sql hh mm\r\n\r\nDECLARE  @Seconds INT\r\n\r\nSET @Seconds = 20000\r\n\r\nSELECT HH = @Seconds \/ 3600, MM = (@Seconds%3600) \/ 60, SS = (@Seconds%60)\r\n\r\n\/* HH    MM    SS\r\n\r\n5     33    20   *\/\r\n\r\n------------\r\n\r\n-- SQL Server Date Only from DATETIME column - get date only\r\n\r\n-- T-SQL just date - truncate time from datetime - remove time part\r\n\r\n------------\r\n\r\nDECLARE @Now datetime = CURRENT_TIMESTAMP -- getdate()\r\n\r\nSELECT  DateAndTime       = @Now      -- Date portion and Time portion\r\n\r\n,DateString        = REPLACE(LEFT(CONVERT (varchar, @Now, 112),10),' ','-')\r\n\r\n,[Date]            = CONVERT(DATE, @Now)  -- SQL Server 2008 and on - date part\r\n\r\n,Midnight1         = dateadd(day, datediff(day,0, @Now), 0)\r\n\r\n,Midnight2         = CONVERT(DATETIME,CONVERT(int, @Now))\r\n\r\n,Midnight3         = CONVERT(DATETIME,CONVERT(BIGINT,@Now) &amp;                                                           (POWER(Convert(bigint,2),32)-1))\r\n\r\n\/* DateAndTime    DateString  Date  Midnight1   Midnight2   Midnight3\r\n\r\n2010-11-02 08:00:33.657 20101102    2010-11-02  2010-11-02 00:00:00.000 2010-11-02 00:00:00.000      2010-11-02 00:00:00.000 *\/\r\n\r\n------------\r\n\r\n-- SQL Server 2008 convert datetime to date - sql yyyy mm dd\r\n\r\nSELECT      TOP (3)  OrderDate = CONVERT(date, OrderDate),\r\n\r\nToday = CONVERT(date, getdate())\r\n\r\nFROM AdventureWorks2008.Sales.SalesOrderHeader\r\n\r\nORDER BY newid();\r\n\r\n\/*          OrderDate   Today\r\n\r\n2004-02-15  2012-06-18 .....*\/\r\n\r\n------------\r\n\r\n-- SQL date yyyy mm dd - sqlserver yyyy mm dd - date format yyyymmdd\r\n\r\nSELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY\/MM\/DD]\r\n\r\n\/*  YYYY\/MM\/DD\r\n\r\n2015\/07\/11    *\/\r\n\r\nSELECT CONVERT(VARCHAR(10), GETDATE(), 112) AS [YYYYMMDD]\r\n\r\n\/*  YYYYMMDD\r\n\r\n20150711     *\/\r\n\r\nSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111),'\/',' ') AS [YYYY MM DD]\r\n\r\n\/* YYYY MM DD\r\n\r\n2015 07 11    *\/\r\n-- Converting to special (non-standard) date fomats: DD-MMM-YY\r\nSELECT UPPER(REPLACE(CONVERT(VARCHAR,GETDATE(),6),' ','-'))\r\n-- 07-MAR-14\r\n------------\r\n\r\n-- SQL convert date string to datetime - time set to 00:00:00.000 or 12:00AM\r\n\r\nPRINT CONVERT(datetime,'07-10-2012',110)        -- Jul 10 2012 12:00AM\r\n\r\nPRINT CONVERT(datetime,'2012\/07\/10',111)        -- Jul 10 2012 12:00AM\r\n\r\nPRINT CONVERT(datetime,'20120710',  112)        -- Jul 10 2012 12:00AM\r\n\r\n------------\r\n\r\n-- UNIX to SQL Server datetime conversion\r\n\r\ndeclare @UNIX bigint  = 1477216861;\r\n\r\nselect dateadd(ss,@UNIX,'19700101'); -- 2016-10-23 10:01:01.000\r\n------------\r\n\r\n-- String to date conversion - sql date yyyy mm dd - sql date formatting\r\n\r\n-- SQL Server cast string to date - sql convert date to datetime\r\n\r\nSELECT [Date] = CAST (@DateValue AS datetime)\r\n\r\n-- 2012-07-18 00:00:00.000\r\n\r\n-- SQL convert string date to different style - sql date string formatting\r\n\r\nSELECT CONVERT(varchar, CONVERT(datetime, '20140508'), 100)\r\n\r\n-- May  8 2014 12:00AM\r\n\r\n-- SQL Server convert date to integer\r\n\r\nDECLARE @Date datetime; SET @Date = getdate();\r\n\r\nSELECT DateAsInteger = CAST (CONVERT(varchar,@Date,112) as INT);\r\n\r\n-- Result: 20161225\r\n\r\n-- SQL Server convert integer to datetime\r\n\r\nDECLARE @iDate int\r\n\r\nSET @iDate = 20151225\r\n\r\nSELECT IntegerToDatetime = CAST(convert(varchar,@iDate) as datetime)\r\n\r\n-- 2015-12-25 00:00:00.000\r\n\r\n-- Alternates: date-only datetime values\r\n\r\n-- SQL Server floor date - sql convert datetime\r\n\r\nSELECT [DATE-ONLY]=CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, GETDATE())))\r\n\r\nSELECT [DATE-ONLY]=CONVERT(DATETIME, FLOOR(CONVERT(MONEY, GETDATE())))\r\n\r\n-- SQL Server cast string to datetime\r\n\r\n-- SQL Server datetime to string convert\r\n\r\nSELECT [DATE-ONLY]=CAST(CONVERT(varchar, GETDATE(), 101) AS DATETIME)\r\n\r\n-- SQL Server dateadd function - T-SQL datediff function\r\n\r\n-- SQL strip time from date - MSSQL strip time from datetime\r\n\r\nSELECT getdate() ,dateadd(dd, datediff(dd, 0, getdate()), 0)\r\n\r\n-- Results: 2016-01-23 05:35:52.793 2016-01-23 00:00:00.000\r\n\r\n-- String date  - 10 bytes of storage\r\n\r\nSELECT [STRING DATE]=CONVERT(varchar,  GETDATE(), 110)\r\n\r\nSELECT [STRING DATE]=CONVERT(varchar,  CURRENT_TIMESTAMP, 110)\r\n\r\n-- Same results: 01-02-2012\r\n\r\n-- SQL Server cast datetime as string - sql datetime formatting\r\n\r\nSELECT stringDateTime=CAST (getdate() as varchar) -- Dec 29 2012  3:47AM\r\n\r\n----------\r\n\r\n-- SQL date range BETWEEN operator\r\n\r\n----------\r\n\r\n-- SQL date range select - date range search - T-SQL date range query\r\n\r\n-- Count Sales Orders for 2003 OCT-NOV\r\n\r\nDECLARE  @StartDate DATETIME,  @EndDate DATETIME\r\n\r\nSET @StartDate = convert(DATETIME,'10\/01\/2003',101)\r\n\r\nSET @EndDate   = convert(DATETIME,'11\/30\/2003',101)\r\n\r\nSELECT @StartDate, @EndDate\r\n\r\n-- 2003-10-01 00:00:00.000  2003-11-30 00:00:00.000\r\n\r\nSELECT dateadd(DAY,1,@EndDate),\r\n\r\ndateadd(ms,-3,dateadd(DAY,1,@EndDate))\r\n\r\n-- 2003-12-01 00:00:00.000  2003-11-30 23:59:59.997\r\n\r\n-- MSSQL date range select using &gt;= and &lt;\r\n\r\nSELECT [Sales Orders for 2003 OCT-NOV] = COUNT(* )\r\n\r\nFROM   Sales.SalesOrderHeader\r\n\r\nWHERE  OrderDate &gt;= @StartDate AND OrderDate &lt; dateadd(DAY,1,@EndDate)\r\n\r\n\/* Sales Orders for 2003 OCT-NOV\r\n\r\n3668 *\/\r\n\r\n-- Equivalent date range query using BETWEEN comparison\r\n\r\n-- It requires a bit of trick programming\r\n\r\nSELECT [Sales Orders for 2003 OCT-NOV] = COUNT(* )\r\n\r\nFROM   Sales.SalesOrderHeader\r\n\r\nWHERE  OrderDate BETWEEN @StartDate AND dateadd(ms,-3,dateadd(DAY,1,@EndDate))\r\n\r\n-- 3668\r\n\r\nUSE AdventureWorks;\r\n\r\n-- SQL between string dates\r\n\r\nSELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader\r\n\r\nWHERE OrderDate BETWEEN '20040201' AND '20040210' -- Result: 108\r\n\r\n-- SQL BETWEEN dates without time - time stripped - time removed - date part only\r\n\r\nSELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader\r\n\r\nWHERE datediff(dd,0,OrderDate)\r\n\r\nBETWEEN datediff(dd,0,'20040201 12:11:39') AND datediff(dd,0,'20040210 14:33:19')\r\n\r\n-- 108\r\n\r\n-- BETWEEN is equivalent to &gt;=...AND....&lt;=\r\n\r\nSELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader\r\n\r\nWHERE OrderDate\r\n\r\nBETWEEN '2004-02-01 00:00:00.000' AND '2004-02-10  00:00:00.000'\r\n\r\n\/* Orders with OrderDates\r\n\r\n'2004-02-10  00:00:01.000'  - 1 second after midnight (12:00AM)\r\n\r\n'2004-02-10  00:01:00.000'  - 1 minute after midnight\r\n\r\n'2004-02-10  01:00:00.000'  - 1 hour after midnight\r\n\r\nare not included in the two queries above. *\/\r\n\r\n-- To include the entire day of 2004-02-10 use:\r\n\r\nSELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader\r\n\r\nWHERE OrderDate &gt;= '20040201' AND OrderDate &lt; '20040211'\r\n\r\n----------\r\n\r\n-- Calculate week ranges in a year\r\n\r\n----------\r\n\r\nDECLARE @Year INT = '2016';\r\n\r\nWITH cteDays AS (SELECT DayOfYear=Dateadd(dd, number,\r\n\r\nCONVERT(DATE, CONVERT(char(4),@Year)+'0101'))\r\n\r\nFROM master.dbo.spt_values WHERE type='P'),\r\n\r\nCTE AS (SELECT DayOfYear, WeekOfYear=DATEPART(week,DayOfYear)\r\n\r\nFROM cteDays WHERE YEAR(DayOfYear)= @YEAR)\r\n\r\nSELECT WeekOfYear, StartOfWeek=MIN(DayOfYear), EndOfWeek=MAX(DayOfYear)\r\n\r\nFROM CTE  GROUP BY WeekOfYear ORDER BY WeekOfYear\r\n\r\n------------\r\n\r\n-- Date validation function ISDATE - returns 1 or 0 - SQL datetime functions\r\n\r\n------------\r\n\r\nDECLARE @StringDate varchar(32)\r\n\r\nSET @StringDate = '2011-03-15 18:50'\r\n\r\nIF EXISTS( SELECT * WHERE ISDATE(@StringDate) = 1)\r\n\r\nPRINT 'VALID DATE: ' + @StringDate\r\n\r\nELSE\r\n\r\nPRINT 'INVALID DATE: ' + @StringDate\r\n\r\nGO\r\n\r\n-- Result: VALID DATE: 2011-03-15 18:50\r\n\r\nDECLARE @StringDate varchar(32)\r\n\r\nSET @StringDate = '20112-03-15 18:50'\r\n\r\nIF EXISTS( SELECT * WHERE ISDATE(@StringDate) = 1)\r\n\r\nPRINT 'VALID DATE: ' + @StringDate\r\n\r\nELSE  PRINT 'INVALID DATE: ' + @StringDate\r\n\r\n-- Result: INVALID DATE: 20112-03-15 18:50\r\n\r\n-- First and last day of date periods - SQL Server 2008 and on code\r\n\r\nDECLARE @Date DATE = '20161023'\r\n\r\nSELECT ReferenceDate   = @Date\r\n\r\nSELECT FirstDayOfYear  = CONVERT(DATE, dateadd(yy, datediff(yy,0, @Date),0))\r\n\r\nSELECT LastDayOfYear   = CONVERT(DATE, dateadd(yy, datediff(yy,0, @Date)+1,-1))\r\n\r\nSELECT FDofSemester = CONVERT(DATE, dateadd(qq,((datediff(qq,0,@Date)\/2)*2),0))\r\n\r\nSELECT LastDayOfSemester\r\n\r\n= CONVERT(DATE, dateadd(qq,((datediff(qq,0,@Date)\/2)*2)+2,-1))\r\n\r\nSELECT FirstDayOfQuarter  = CONVERT(DATE, dateadd(qq, datediff(qq,0, @Date),0))\r\n\r\n-- 2016-10-01\r\n\r\nSELECT LastDayOfQuarter = CONVERT(DATE, dateadd(qq, datediff(qq,0,@Date)+1,-1))\r\n\r\n-- 2016-12-31\r\n\r\nSELECT FirstDayOfMonth = CONVERT(DATE, dateadd(mm, datediff(mm,0, @Date),0))\r\n\r\nSELECT LastDayOfMonth  = CONVERT(DATE, dateadd(mm, datediff(mm,0, @Date)+1,-1))\r\n\r\nSELECT FirstDayOfWeek  = CONVERT(DATE, dateadd(wk, datediff(wk,0, @Date),0))\r\n\r\nSELECT LastDayOfWeek   = CONVERT(DATE, dateadd(wk, datediff(wk,0, @Date)+1,-1))\r\n\r\n-- 2016-10-30\r\n\r\n-- Month sequence generator - sequential numbers \/ dates\r\n\r\nDECLARE @Date date = '2000-01-01'\r\n\r\nSELECT MonthStart=dateadd(MM, number, @Date)\r\n\r\nFROM  master.dbo.spt_values\r\n\r\nWHERE type='P' AND  dateadd(MM, number, @Date) &lt;= CURRENT_TIMESTAMP\r\n\r\nORDER BY MonthStart\r\n\r\n\/* MonthStart\r\n\r\n2000-01-01\r\n\r\n2000-02-01\r\n\r\n2000-03-01 ....*\/\r\n\r\n------------\r\n\r\n-- Selected named date styles\r\n------------\r\n\r\nDECLARE @DateTimeValue varchar(32)\r\n\r\n-- US-Style\r\n\r\nSELECT @DateTimeValue = '10\/23\/2016'\r\n\r\nSELECT StringDate=@DateTimeValue,\r\n\r\n[US-Style] = CONVERT(datetime, @DatetimeValue)\r\n\r\nSELECT @DateTimeValue = '10\/23\/2016 23:01:05'\r\n\r\nSELECT StringDate = @DateTimeValue,\r\n\r\n[US-Style] = CONVERT(datetime, @DatetimeValue)\r\n\r\n-- UK-Style, British\/French - convert string to datetime sql\r\n\r\n-- sql convert string to datetime\r\n\r\nSELECT @DateTimeValue = '23\/10\/16 23:01:05'\r\n\r\nSELECT StringDate = @DateTimeValue,\r\n\r\n[UK-Style] = CONVERT(datetime, @DatetimeValue, 3)\r\n\r\nSELECT @DateTimeValue = '23\/10\/2016 04:01 PM'\r\n\r\nSELECT StringDate = @DateTimeValue,\r\n\r\n[UK-Style] = CONVERT(datetime, @DatetimeValue, 103)\r\n\r\n-- German-Style\r\n\r\nSELECT @DateTimeValue = '23.10.16 23:01:05'\r\n\r\nSELECT StringDate = @DateTimeValue,\r\n\r\n[German-Style] = CONVERT(datetime, @DatetimeValue, 4)\r\n\r\nSELECT @DateTimeValue = '23.10.2016 04:01 PM'\r\n\r\nSELECT StringDate = @DateTimeValue,\r\n\r\n[German-Style] = CONVERT(datetime, @DatetimeValue, 104)\r\n\r\n------------\r\n\r\n-- Double conversion to US-Style 107 with century: Oct 23, 2016\r\n\r\nSET @DateTimeValue='10\/23\/16'\r\n\r\nSELECT StringDate=@DateTimeValue,\r\n\r\n[US-Style] = CONVERT(varchar, CONVERT(datetime, @DateTimeValue),107)\r\n\r\n-- Using DATEFORMAT - UK-Style - SQL dateformat\r\n\r\nSET @DateTimeValue='23\/10\/16'\r\n\r\nSET DATEFORMAT dmy\r\n\r\nSELECT StringDate=@DateTimeValue,\r\n\r\n[Date Time] = CONVERT(datetime, @DatetimeValue)\r\n\r\n-- Using DATEFORMAT - US-Style\r\n\r\nSET DATEFORMAT mdy\r\n-- Finding out date format for a session\r\n\r\nSELECT session_id, date_format from sys.dm_exec_sessions\r\n\r\n------------\r\n\r\n-- Convert date string from DD\/MM\/YYYY UK format to MM\/DD\/YYYY US format\r\nDECLARE @UKdate char(10) = '15\/03\/2016'\r\nSELECT CONVERT(CHAR(10), CONVERT(datetime, @UKdate,103),101)\r\n\r\n-- 03\/15\/2016\r\n\r\n-- DATEPART datetime function example - SQL Server datetime functions\r\n\r\nSELECT * FROM Northwind.dbo.Orders\r\n\r\nWHERE DATEPART(YEAR, OrderDate) = '1996' AND\r\n\r\nDATEPART(MONTH,OrderDate) = '07'   AND\r\n\r\nDATEPART(DAY, OrderDate)  = '10'\r\n\r\n-- Alternate syntax for DATEPART example\r\n\r\nSELECT * FROM Northwind.dbo.Orders\r\n\r\nWHERE YEAR(OrderDate)         = '1996' AND\r\n\r\nMONTH(OrderDate)        = '07'   AND\r\n\r\nDAY(OrderDate)          = '10'\r\n\r\n------------\r\n\r\n-- T-SQL calculate the number of business days function \/ UDF - exclude SAT &amp; SUN\r\n\r\n------------\r\n\r\nCREATE FUNCTION fnBusinessDays (@StartDate DATETIME, @EndDate   DATETIME)\r\n\r\nRETURNS INT AS\r\n\r\nBEGIN\r\n\r\nIF (@StartDate IS NULL OR @EndDate IS NULL)  RETURN (0)\r\n\r\nDECLARE  @i INT = 0;\r\n\r\nWHILE (@StartDate &lt;= @EndDate)\r\n\r\nBEGIN\r\n\r\nSET @i = @i + CASE\r\n\r\nWHEN datepart(dw,@StartDate) BETWEEN 2 AND 6 THEN 1\r\n\r\nELSE 0\r\n\r\nEND\r\n\r\nSET @StartDate = @StartDate + 1\r\n\r\nEND  -- while\r\n\r\nRETURN (@i)\r\n\r\nEND -- function\r\n\r\nGO\r\n\r\nSELECT dbo.fnBusinessDays('2016-01-01','2016-12-31')\r\n\r\n-- 261\r\n\r\n------------\r\n\r\n-- T-SQL DATENAME function usage for weekdays\r\n\r\nSELECT DayName=DATENAME(weekday, OrderDate), SalesPerWeekDay = COUNT(*)\r\n\r\nFROM AdventureWorks2008.Sales.SalesOrderHeader\r\n\r\nGROUP BY DATENAME(weekday, OrderDate), DATEPART(weekday,OrderDate)\r\n\r\nORDER BY DATEPART(weekday,OrderDate)\r\n\r\n\/* DayName   SalesPerWeekDay\r\n\r\nSunday      4482\r\n\r\nMonday      4591\r\n\r\nTuesday     4346.... *\/\r\n\r\n-- DATENAME application for months\r\n\r\nSELECT MonthName=DATENAME(month, OrderDate), SalesPerMonth = COUNT(*)\r\n\r\nFROM AdventureWorks2008.Sales.SalesOrderHeader\r\n\r\nGROUP BY DATENAME(month, OrderDate), MONTH(OrderDate) ORDER BY MONTH(OrderDate)\r\n\r\n\/* MonthName      SalesPerMonth\r\n\r\nJanuary           2483\r\n\r\nFebruary          2686\r\n\r\nMarch             2750\r\n\r\nApril             2740....  *\/\r\n\r\n-- Getting month name from month number\r\n\r\nSELECT DATENAME(MM,dateadd(MM,7,-1))  -- July\r\n\r\n------------\r\n-- Extract string date from text with PATINDEX pattern matching\r\n\r\n-- Apply sql server string to date conversion\r\n\r\n------------\r\n\r\nUSE tempdb;\r\n\r\ngo\r\n\r\nCREATE TABLE InsiderTransaction (\r\n\r\nInsiderTransactionID int identity primary key,\r\n\r\nTradeDate datetime,\r\n\r\nTradeMsg varchar(256),\r\n\r\nModifiedDate datetime default (getdate()))\r\n\r\n-- Populate table with dummy data\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC Hammer, Bruce D. CSO 09-02-08 Buy 2,000 6.10')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC Schmidt, Steven CFO 08-25-08 Buy 2,500 6.70')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC  Hammer, Bruce D. CSO  08-20-08 Buy 3,000 8.59')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC Walters,  Jeff CTO 08-15-08  Sell 5,648 8.49')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN  QABC  Walters, Jeff CTO   08-15-08 Option Execute 5,648 2.15')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC Hammer, Bruce D. CSO 07-31-08  Buy 5,000 8.05')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC Lennot, Mark B. Director  08-31-07 Buy 1,500 9.97')\r\n\r\nINSERT InsiderTransaction (TradeMsg) VALUES(\r\n\r\n'INSIDER TRAN QABC  O''Neal, Linda COO  08-01-08 Sell 5,000 6.50')\r\n\r\n-- Extract dates from stock trade message text\r\n\r\n-- Pattern match for MM-DD-YY using the PATINDEX string function\r\n\r\nSELECT TradeDate=substring(TradeMsg,\r\n\r\npatindex('%[01][0-9]-[0123][0-9]-[0-9][0-9]%', TradeMsg),8)\r\n\r\nFROM InsiderTransaction\r\n\r\nWHERE  patindex('%[01][0-9]-[0123][0-9]-[0-9][0-9]%', TradeMsg) &gt; 0\r\n\r\n\/* Partial results\r\n\r\nTradeDate\r\n\r\n09-02-08\r\n\r\n08-25-08\r\n\r\n08-20-08 *\/\r\n\r\n-- Update table with extracted date\r\n\r\n-- Convert string date to datetime\r\n\r\nUPDATE InsiderTransaction\r\n\r\nSET TradeDate = convert(datetime,  substring(TradeMsg,\r\n\r\npatindex('%[01][0-9]-[0123][0-9]-[0-9][0-9]%', TradeMsg),8))\r\n\r\nWHERE  patindex('%[01][0-9]-[0123][0-9]-[0-9][0-9]%', TradeMsg) &gt; 0\r\n\r\nSELECT * FROM InsiderTransaction ORDER BY TradeDate desc\r\n\r\n\/* Partial results\r\n\r\nInsiderTransactionID    TradeDate   TradeMsg    ModifiedDate\r\n\r\n1     2008-09-02 00:00:00.000 INSIDER TRAN QABC Hammer, Bruce D. CSO 09-02-08 Buy 2,000 6.10      2008-12-22 20:25:19.263\r\n\r\n2     2008-08-25 00:00:00.000 INSIDER TRAN QABC Schmidt, Steven CFO 08-25-08 Buy 2,500 6.70      2008-12-22 20:25:19.263 *\/\r\n\r\n-- Cleanup task\r\n\r\nDROP TABLE InsiderTransaction\r\n\r\n\/************\r\n\r\nVALID DATE RANGES FOR DATE \/ DATETIME DATA TYPES\r\n\r\nDATE (3 bytes) date range:\r\n\r\nJanuary 1, 1 A.D. through December 31, 9999 A.D.\r\n\r\nSMALLDATETIME (4 bytes) date range:\r\n\r\nJanuary 1, 1900 through June 6, 2079\r\n\r\nDATETIME (8 bytes) date range:\r\n\r\nJanuary 1, 1753 through December 31, 9999\r\n\r\nDATETIME2 (6-8 bytes) date range:\r\n\r\nJanuary 1, 1 A.D. through December 31, 9999 A.D.\r\n\r\n-- The statement below will give a date range error\r\n\r\nSELECT CONVERT(smalldatetime, '2110-01-01')\r\n\r\n\/* Msg 242, Level 16, State 3, Line 1\r\n\r\nThe conversion of a varchar data type to a smalldatetime data type\r\n\r\nresulted in an out-of-range value. *\/\r\n\r\n************\/\r\n\r\n------------\r\n\r\n-- SQL CONVERT DATE\/DATETIME script applying table variable\r\n\r\n------------\r\n\r\n-- SQL Server convert date\r\n\r\n-- Datetime column is converted into date only string column\r\n\r\nDECLARE @sqlConvertDate TABLE ( DatetimeColumn datetime,\r\n\r\nDateColumn char(10));\r\n\r\nINSERT @sqlConvertDate (DatetimeColumn) SELECT GETDATE()\r\n\r\nUPDATE @sqlConvertDate\r\n\r\nSET DateColumn = CONVERT(char(10), DatetimeColumn, 111)\r\n\r\nSELECT * FROM @sqlConvertDate\r\n\r\n-- SQL Server convert datetime - String date column converted into datetime column\r\n\r\nUPDATE @sqlConvertDate\r\n\r\nSET DatetimeColumn = CONVERT(Datetime, DateColumn, 111)\r\n\r\nSELECT * FROM @sqlConvertDate\r\n\r\n-- Equivalent formulation - SQL Server cast datetime\r\n\r\nUPDATE @sqlConvertDate\r\n\r\nSET DatetimeColumn = CAST(DateColumn AS datetime)\r\n\r\nSELECT * FROM @sqlConvertDate\r\n\r\n\/* First results\r\n\r\nDatetimeColumn                DateColumn\r\n\r\n2012-12-25 15:54:10.363       2012\/12\/25 *\/\r\n\r\n\/* Second results:\r\n\r\nDatetimeColumn                DateColumn\r\n\r\n2012-12-25 00:00:00.000       2012\/12\/25  *\/\r\n\r\n------------\r\n\r\n-- SQL date sequence generation with dateadd &amp; table variable\r\n\r\n-- SQL Server cast datetime to string - SQL Server insert default values method\r\n\r\nDECLARE @Sequence table (Sequence int identity(1,1))\r\n\r\nDECLARE @i int; SET @i = 0\r\n\r\nWHILE ( @i &lt; 500)\r\n\r\nBEGIN\r\n\r\nINSERT @Sequence DEFAULT VALUES\r\n\r\nSET @i = @i + 1\r\n\r\nEND\r\n\r\nSELECT DateSequence = CAST(dateadd(day, Sequence,getdate()) AS varchar)\r\n\r\nFROM @Sequence\r\n\r\n\/* Partial results:\r\n\r\nDateSequence\r\n\r\nDec 31 2008  3:02AM\r\n\r\nJan  1 2009  3:02AM\r\n\r\nJan  2 2009  3:02AM\r\n\r\nJan  3 2009  3:02AM\r\n\r\nJan  4 2009  3:02AM *\/\r\n\r\n-- SETTING FIRST DAY OF WEEK TO SUNDAY\r\n\r\nSET DATEFIRST 7;\r\n\r\nSELECT @@DATEFIRST\r\n\r\n-- 7\r\n\r\nSELECT CAST('2016-10-23' AS date) AS SelectDate\r\n\r\n,DATEPART(dw, '2016-10-23') AS DayOfWeek;\r\n\r\n-- 2016-10-23     1\r\n\r\n------------\r\n\r\n-- SQL Last Week calculations\r\n\r\n------------\r\n\r\n-- SQL last Friday - Implied string to datetime conversions in dateadd &amp; datediff\r\n\r\nDECLARE @BaseFriday CHAR(8), @LastFriday datetime, @LastMonday datetime\r\n\r\nSET @BaseFriday = '19000105'\r\n\r\nSELECT @LastFriday = dateadd(dd,\r\n\r\n(datediff (dd, @BaseFriday, CURRENT_TIMESTAMP) \/ 7) * 7, @BaseFriday)\r\n\r\nSELECT [Last Friday] = @LastFriday\r\n\r\n-- Result: 2008-12-26 00:00:00.000\r\n\r\n-- SQL last Monday (last week's Monday)\r\n\r\nSELECT @LastMonday=dateadd(dd,\r\n\r\n(datediff (dd, @BaseFriday, CURRENT_TIMESTAMP) \/ 7) * 7 - 4,@BaseFriday)\r\n\r\nSELECT [Last Monday]= @LastMonday\r\n\r\n-- Result: 2008-12-22 00:00:00.000\r\n\r\n-- SQL last week - SUN - SAT\r\n\r\nSELECT [Last Week] = CONVERT(varchar,dateadd(day, -1, @LastMonday), 101)+ ' - ' +\r\n\r\nCONVERT(varchar,dateadd(day, 1,  @LastFriday), 101)\r\n\r\n-- Result: 12\/21\/2008 - 12\/27\/2008\r\n\r\n-----------------\r\n\r\n-- Specific day calculations\r\n\r\n------------\r\n\r\n-- First day of current month\r\n\r\nSELECT dateadd(month, datediff(month, 0, getdate()), 0)\r\n\r\n-- 15th day of current month\r\n\r\nSELECT dateadd(day,14,dateadd(month,datediff(month,0,getdate()),0))\r\n\r\n-- First Monday of current month\r\n\r\nSELECT dateadd(day, (9-datepart(weekday,\r\n\r\ndateadd(month, datediff(month, 0, getdate()), 0)))%7,\r\n\r\ndateadd(month, datediff(month, 0, getdate()), 0))\r\n\r\n-- Next Monday calculation from the reference date which was a Monday\r\n\r\nDECLARE @Now datetime = GETDATE();\r\n\r\nDECLARE @NextMonday datetime = dateadd(dd, ((datediff(dd, '19000101', @Now)\r\n\r\n\/ 7) * 7) + 7, '19000101');\r\n\r\nSELECT [Now]=@Now, [Next Monday]=@NextMonday\r\n\r\n-- Last Friday of current month\r\n\r\nSELECT dateadd(day, -7+(6-datepart(weekday,\r\n\r\ndateadd(month, datediff(month, 0, getdate())+1, 0)))%7,\r\n\r\ndateadd(month, datediff(month, 0, getdate())+1, 0))\r\n\r\n-- First day of next month\r\n\r\nSELECT dateadd(month, datediff(month, 0, getdate())+1, 0)\r\n\r\n-- 15th of next month\r\n\r\nSELECT dateadd(day,14, dateadd(month, datediff(month, 0, getdate())+1, 0))\r\n\r\n-- First Monday of next month\r\n\r\nSELECT dateadd(day, (9-datepart(weekday,\r\n\r\ndateadd(month, datediff(month, 0, getdate())+1, 0)))%7,\r\n\r\ndateadd(month, datediff(month, 0, getdate())+1, 0))\r\n\r\n------------\r\n\r\n-- SQL Last Date calculations\r\n\r\n------------\r\n\r\n-- Last day of prior month - Last day of previous month\r\n\r\nSELECT convert( varchar, dateadd(dd,-1,dateadd(mm, datediff(mm,0,getdate() ), 0)),101)\r\n\r\n-- 01\/31\/2019\r\n\r\n-- Last day of current month\r\n\r\nSELECT convert( varchar, dateadd(dd,-1,dateadd(mm, datediff(mm,0,getdate())+1, 0)),101)\r\n\r\n-- 02\/28\/2019\r\n\r\n-- Last day of prior quarter - Last day of previous quarter\r\n\r\nSELECT convert( varchar, dateadd(dd,-1,dateadd(qq, datediff(qq,0,getdate() ), 0)),101)\r\n\r\n-- 12\/31\/2018\r\n\r\n-- Last day of current quarter - Last day of current quarter\r\n\r\nSELECT convert( varchar, dateadd(dd,-1,dateadd(qq, datediff(qq,0,getdate())+1, 0)),101)\r\n\r\n-- 03\/31\/2019\r\n\r\n-- Last day of prior year - Last day of previous year\r\n\r\nSELECT convert( varchar, dateadd(dd,-1,dateadd(yy, datediff(yy,0,getdate() ), 0)),101)\r\n\r\n-- 12\/31\/2018\r\n\r\n-- Last day of current year\r\n\r\nSELECT convert( varchar, dateadd(dd,-1,dateadd(yy, datediff(yy,0,getdate())+1, 0)),101)\r\n\r\n-- 12\/31\/2019\r\n\r\n------------\r\n\r\n-- SQL Server dateformat and language setting\r\n\r\n------------\r\n\r\n-- T-SQL set language - String to date conversion\r\n\r\nSET LANGUAGE us_english\r\n\r\nSELECT CAST('2018-03-15' AS datetime)\r\n\r\n-- 2018-03-15 00:00:00.000\r\n\r\nSET LANGUAGE british\r\n\r\nSELECT CAST('2018-03-15' AS datetime)\r\n\r\n\/* Msg 242, Level 16, State 3, Line 2\r\n\r\nThe conversion of a varchar data type to a datetime data type resulted in\r\n\r\nan out-of-range value.\r\n\r\n*\/\r\n\r\nSELECT CAST('2018-15-03' AS datetime)\r\n\r\n-- 2018-03-15 00:00:00.000\r\n\r\nSET LANGUAGE us_english\r\n\r\n-- SQL dateformat with language dependency\r\n\r\nSELECT name, alias, dateformat\r\n\r\nFROM sys.syslanguages\r\n\r\nWHERE langid in (0,1,2,4,5,6,7,10,11,13,23,31)\r\n\r\nGO\r\n\r\n\/*\r\n\r\nname        alias             dateformat\r\n\r\nus_english  English           mdy\r\n\r\nDeutsch     German            dmy\r\n\r\nFran\u00e7ais    French            dmy\r\n\r\nDansk       Danish            dmy\r\n\r\nEspa\u00f1ol     Spanish           dmy\r\n\r\nItaliano    Italian           dmy\r\n\r\nNederlands  Dutch             dmy\r\n\r\nSuomi       Finnish           dmy\r\n\r\nSvenska     Swedish           ymd\r\n\r\nmagyar      Hungarian         ymd\r\n\r\nBritish     British English   dmy\r\n\r\nArabic      Arabic            dmy *\/\r\n\r\n------------\r\n\r\n-- Generate list of months\r\n\r\n;WITH CTE AS (\r\n\r\nSELECT      1 MonthNo, CONVERT(DATE, '19000101') MonthFirst\r\n\r\nUNION ALL\r\n\r\nSELECT      MonthNo+1, DATEADD(Month, 1, MonthFirst)\r\n\r\nFROM  CTE WHERE   Month(MonthFirst) &lt; 12   )\r\n\r\nSELECT      MonthNo AS MonthNumber, DATENAME(MONTH, MonthFirst) AS MonthName\r\n\r\nFROM  CTE ORDER BY MonthNo\r\n\r\n\/* MonthNumber    MonthName\r\n\r\n1           January\r\n\r\n2           February\r\n\r\n3           March  ... *\/\r\n\r\n------------<\/pre>\n<p>&nbsp;<\/p>\n<p>[button size=&#8221;mini&#8221; type=&#8221;info&#8221; value=&#8221;Kaynak&#8221; href=&#8221;http:\/\/www.sqlusa.com\/bestpractices\/datetimeconversion\/&#8221;]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Date Time\u00a0conversion \/ Tarih zaman d\u00f6n\u00fc\u015f\u00fcmleri MSSQL &#8216;de \u00e7ok kulland\u0131\u011f\u0131m\u0131z d\u00f6n\u00fc\u015f\u00fcm d\u00f6n\u00fc\u015f\u00fcm kodlar\u0131 ve \u00f6rnekleri SQL Server string to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[42,149,15],"class_list":["post-194","post","type-post","status-publish","format-standard","hentry","category-yazilim","tag-datetime","tag-sql","tag-t-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"VeYSeL","author_link":"https:\/\/dijitalturk.com\/veysel\/author\/veysel\/"},"uagb_comment_info":0,"uagb_excerpt":"SQL Date Time\u00a0conversion \/ Tarih zaman d\u00f6n\u00fc\u015f\u00fcmleri MSSQL &#8216;de \u00e7ok kulland\u0131\u011f\u0131m\u0131z d\u00f6n\u00fc\u015f\u00fcm d\u00f6n\u00fc\u015f\u00fcm kodlar\u0131 ve \u00f6rnekleri SQL Server string to [&hellip;]","_links":{"self":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/comments?post=194"}],"version-history":[{"count":0,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/194\/revisions"}],"wp:attachment":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media?parent=194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/categories?post=194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/tags?post=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}