{"id":280,"date":"2013-07-24T11:33:27","date_gmt":"2013-07-24T15:33:27","guid":{"rendered":"http:\/\/binaryworld.net\/blogs\/?p=280"},"modified":"2014-02-27T09:33:28","modified_gmt":"2014-02-27T14:33:28","slug":"t-sql-date-format-function-fndateformat-like-net","status":"publish","type":"post","link":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/","title":{"rendered":"T-SQL Date Format Function &#8211; fnDateFormat like .net"},"content":{"rendered":"<p>Here is reusable function which can be used to format SQL dateTime to any format like C# or VB.net<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\r\nDROP FUNCTION dbo.fnFormatDate\r\nGO\r\nCREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(100))\r\nRETURNS VARCHAR(100)\r\nAS\r\nBEGIN\r\n\r\n    DECLARE @StringDate VARCHAR(100)\r\n\r\n    SET @StringDate = @FormatMask\r\n\r\n\t--\/\/GO BY CERTAIN ORDER coz IF you replace M before MI then you will lose Minute format\r\n    \r\n    IF (CHARINDEX (&#039;MI&#039;,@StringDate) &gt; 0) --&quot;##&quot;\r\n       SET @StringDate = REPLACE(@StringDate, &#039;MI&#039;,RIGHT(&#039;0&#039;+DATENAME(MI, @Datetime),2))\r\n\r\n    IF (CHARINDEX (&#039;YYYY&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;YYYY&#039;,DATENAME(YY, @Datetime))\r\n    IF (CHARINDEX (&#039;YY&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;YY&#039;,RIGHT(DATENAME(YY, @Datetime),2))\r\n    IF (CHARINDEX (&#039;Month&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;Month&#039;,DATENAME(MM, @Datetime))\r\n    IF (CHARINDEX (&#039;MON&#039;,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS)&gt;0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;MON&#039;,LEFT(UPPER(DATENAME(MM, @Datetime)),3))\r\n    IF (CHARINDEX (&#039;Mon&#039;,@StringDate) &gt; 0)\r\n\t\tSET @StringDate = REPLACE(@StringDate, &#039;Mon&#039;,LEFT(DATENAME(MM, @Datetime),3))\r\n    IF (CHARINDEX (&#039;MM&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;MM&#039;,RIGHT(&#039;0&#039;+CONVERT(VARCHAR,DATEPART(MM, @Datetime)),2))\r\n\r\n     \r\n    IF (CHARINDEX (&#039;DD&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;DD&#039;,RIGHT(&#039;0&#039;+DATEPART(DD, @Datetime),2))\r\n\r\n    IF (CHARINDEX (&#039;HH&#039;,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS) &gt; 0) --24 Hour format\r\n       SET @StringDate = REPLACE(@StringDate,&#039;HH&#039;, RIGHT(&#039;0&#039;+DATEPART(HH, @Datetime),2))   \r\n    IF (CHARINDEX (&#039;H&#039;,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS) &gt; 0) --24 Hour\r\n       SET @StringDate = REPLACE(@StringDate, &#039;H&#039;, DATEPART(HH, @Datetime))\r\n\r\n\tdeclare @hh12 int\r\n    IF (CHARINDEX (&#039;hh&#039;,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS) &gt; 0) --12 Hour format\r\n    begin\r\n\t\tset @hh12=DATEPART(HH, @Datetime)\r\n\t\tif @hh12&gt;12\r\n\t\t\tset @hh12=@hh12-12\r\n       SET @StringDate = REPLACE(@StringDate,&#039;hh&#039;, RIGHT(&#039;0&#039;+ @hh12,2))   \r\n    end\r\n    IF (CHARINDEX (&#039;h&#039;,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS) &gt; 0) --12 Hour format\r\n    begin\r\n\t\tset @hh12=DATEPART(HH, @Datetime)\r\n\t\tif @hh12&gt;12\r\n\t\t\tset @hh12=@hh12-12\r\n       SET @StringDate = REPLACE(@StringDate,&#039;h&#039;, @hh12)\r\n    end\r\n           \r\n    IF (CHARINDEX (&#039;SS&#039;,@StringDate ) &gt; 0) --second ##\r\n       SET @StringDate = REPLACE(@StringDate,&#039;SS&#039;, RIGHT(&#039;0&#039;+DATEPART(SS, @Datetime),2))   \r\n\r\n    IF (CHARINDEX (&#039;MCS&#039;,@StringDate ) &gt; 0) --micro second ##\r\n       SET @StringDate = REPLACE(@StringDate,&#039;MCS&#039;, DATEPART(MCS, @Datetime))   \r\n\r\n    IF (CHARINDEX (&#039;NS&#039;,@StringDate ) &gt; 0) --micro second ##\r\n       SET @StringDate = REPLACE(@StringDate,&#039;NS&#039;, DATEPART(NS, @Datetime))   \r\n\r\n\r\n--\t.\/\/Replace Single Format Specs after all double specs done\r\n    IF (CHARINDEX (&#039;N&#039;,@StringDate) &gt; 0) --Minute &quot;#&quot;\r\n       SET @StringDate = REPLACE(@StringDate, &#039;N&#039;,DATEPART(MI, @Datetime))\r\n\t\r\n    IF (CHARINDEX (&#039;S&#039;,@StringDate ) &gt; 0) -- second #\r\n       SET @StringDate = REPLACE(@StringDate, &#039;S&#039;, DATEPART(SS, @Datetime))\r\n\r\n    IF (CHARINDEX (&#039;M&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;M&#039;,CONVERT(VARCHAR,DATEPART(MM, @Datetime)))\r\n   \r\n\r\n\tdeclare @ampm varchar(10)\r\n    IF (CHARINDEX (&#039;TT&#039;,@StringDate) &gt; 0) --AM or PM\r\n    begin\r\n\t\tset @hh12=DATEPART(HH, @Datetime)\r\n\t\tif @hh12&gt;12\r\n\t\t\tset @ampm=&#039;PM&#039;\r\n\t\telse\r\n\t\t\tset @ampm=&#039;AM&#039;\r\n       SET @StringDate = REPLACE(@StringDate,&#039;TT&#039;, @ampm)\r\n    end\r\n\r\n    IF (CHARINDEX (&#039;T&#039;,@StringDate) &gt; 0) --A or P\r\n    begin\r\n\t\tset @hh12=DATEPART(HH, @Datetime)\r\n\t\tif @hh12&gt;12\r\n\t\t\tset @ampm=&#039;P&#039;\r\n\t\telse\r\n\t\t\tset @ampm=&#039;A&#039;\r\n       SET @StringDate = REPLACE(@StringDate,&#039;T&#039;, @ampm)\r\n    end\r\n\r\n    IF (CHARINDEX (&#039;D&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;D&#039;,DATEPART(DD, @Datetime))   \r\n\r\n    IF (CHARINDEX (&#039;WWWW&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;WWWW&#039;,LEFT (DATENAME(weekday, @Datetime),3))\r\n\r\n    IF (CHARINDEX (&#039;WWW&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;WWW&#039;,DATENAME(weekday, @Datetime))\r\n\r\n    IF (CHARINDEX (&#039;WW&#039;,@StringDate) &gt; 0)\r\n       SET @StringDate = REPLACE(@StringDate, &#039;WW&#039;,DATENAME(wk, @Datetime))\r\n       \r\nRETURN @StringDate\r\n\r\nEND\r\n\r\nGO\r\n\r\nselect DATENAME(DW,&#039;1\/1\/2013 11:00:00 PM&#039;) \r\n--select DATENAME(DW,&#039;1\/1\/2013 11:00:00 PM&#039;) \r\nSELECT dbo.fnFormatDate (getdate(), &#039;MM\/DD\/YYYY&#039;) -- 07\/24\/2013\r\nSELECT dbo.fnFormatDate (getdate(), &#039;MM DD,YY HH:MI:SS.ms.mcs.ns&#039;) -- 07 24,13 11:10:58.758.843000.843000000\r\nSELECT dbo.fnFormatDate (getdate(), &#039;MM DD,YY HH:MI:SS TT&#039;) -- 07 24,13 11:15:56 AM\r\nSELECT dbo.fnFormatDate (getdate(), &#039;MON DD,YY&#039;) -- JUL 24,13\r\nSELECT dbo.fnFormatDate (getdate(), &#039;mon DD,YY&#039;) -- Jul 24,13\r\nSELECT dbo.fnFormatDate (getdate(), &#039;month DD,YY&#039;) -- July 24,13\r\nSELECT dbo.fnFormatDate (getdate(), &#039;WW WWW WWWW dd-mm-yy, hh:mi:ss.ms tt&#039;) -- 30 Wednesday Wed 24-07-13, 11:35:17.717 AM\r\n--12 Hour format\r\nSELECT dbo.fnFormatDate (&#039;1\/1\/2013 23:59:59&#039;, &#039;MM DD,YY hh:MI:SS TT&#039;) -- 07 24,13 11:31:7 AM\r\n--24 Hour format\r\nSELECT dbo.fnFormatDate (&#039;1\/1\/2013 23:59:59&#039;, &#039;MM DD,YY HH:MI:SS TT&#039;) -- 07 24,13 23:31:7 AM\r\ngo\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is reusable function which can be used to format SQL dateTime to any format like C# or VB.net DROP FUNCTION dbo.fnFormatDate GO CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(100)) RETURNS VARCHAR(100) AS BEGIN DECLARE @StringDate VARCHAR(100) SET @StringDate = &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/\"> <span class=\"screen-reader-text\">T-SQL Date Format Function &#8211; fnDateFormat like .net<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":606,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,35],"tags":[158,85],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>T-SQL Date Format Function - fnDateFormat like .net  - BinaryWorld Blog<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"T-SQL Date Format Function - fnDateFormat like .net  - BinaryWorld Blog\" \/>\r\n<meta property=\"og:description\" content=\"Here is reusable function which can be used to format SQL dateTime to any format like C# or VB.net DROP FUNCTION dbo.fnFormatDate GO CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(100)) RETURNS VARCHAR(100) AS BEGIN DECLARE @StringDate VARCHAR(100) SET @StringDate = &hellip; T-SQL Date Format Function &#8211; fnDateFormat like .net Read More &raquo;\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/\" \/>\r\n<meta property=\"og:site_name\" content=\"BinaryWorld Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2013-07-24T15:33:27+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2014-02-27T14:33:28+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"150\" \/>\r\n\t<meta property=\"og:image:height\" content=\"150\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"Binary World\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Binary World\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/\",\"url\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/\",\"name\":\"T-SQL Date Format Function - fnDateFormat like .net - BinaryWorld Blog\",\"isPartOf\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg\",\"datePublished\":\"2013-07-24T15:33:27+00:00\",\"dateModified\":\"2014-02-27T14:33:28+00:00\",\"author\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0\"},\"breadcrumb\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#primaryimage\",\"url\":\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg\",\"contentUrl\":\"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg\",\"width\":150,\"height\":150,\"caption\":\"T SQL Date format convert function\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/binaryworld.net\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T-SQL Date Format Function &#8211; fnDateFormat like .net\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#website\",\"url\":\"https:\/\/binaryworld.net\/blogs\/\",\"name\":\"BinaryWorld Blog\",\"description\":\"Tips and Tutorials for Microsoft SQL Server, SSIS, SSAS, Business Intelligence, C#, .net\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/binaryworld.net\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0\",\"name\":\"Binary World\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g\",\"caption\":\"Binary World\"},\"description\":\"Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.\",\"url\":\"https:\/\/binaryworld.net\/blogs\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T-SQL Date Format Function - fnDateFormat like .net  - BinaryWorld Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/","og_locale":"en_US","og_type":"article","og_title":"T-SQL Date Format Function - fnDateFormat like .net  - BinaryWorld Blog","og_description":"Here is reusable function which can be used to format SQL dateTime to any format like C# or VB.net DROP FUNCTION dbo.fnFormatDate GO CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(100)) RETURNS VARCHAR(100) AS BEGIN DECLARE @StringDate VARCHAR(100) SET @StringDate = &hellip; T-SQL Date Format Function &#8211; fnDateFormat like .net Read More &raquo;","og_url":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/","og_site_name":"BinaryWorld Blog","article_published_time":"2013-07-24T15:33:27+00:00","article_modified_time":"2014-02-27T14:33:28+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg","type":"image\/jpeg"}],"author":"Binary World","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Binary World","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/","url":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/","name":"T-SQL Date Format Function - fnDateFormat like .net - BinaryWorld Blog","isPartOf":{"@id":"https:\/\/binaryworld.net\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#primaryimage"},"image":{"@id":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#primaryimage"},"thumbnailUrl":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg","datePublished":"2013-07-24T15:33:27+00:00","dateModified":"2014-02-27T14:33:28+00:00","author":{"@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0"},"breadcrumb":{"@id":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#primaryimage","url":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg","contentUrl":"https:\/\/binaryworld.net\/blogs\/wp-content\/uploads\/2014\/02\/sql-server-logo-e1397590261883.jpg","width":150,"height":150,"caption":"T SQL Date format convert function"},{"@type":"BreadcrumbList","@id":"https:\/\/binaryworld.net\/blogs\/t-sql-date-format-function-fndateformat-like-net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/binaryworld.net\/blogs\/"},{"@type":"ListItem","position":2,"name":"T-SQL Date Format Function &#8211; fnDateFormat like .net"}]},{"@type":"WebSite","@id":"https:\/\/binaryworld.net\/blogs\/#website","url":"https:\/\/binaryworld.net\/blogs\/","name":"BinaryWorld Blog","description":"Tips and Tutorials for Microsoft SQL Server, SSIS, SSAS, Business Intelligence, C#, .net","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/binaryworld.net\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0","name":"Binary World","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g","caption":"Binary World"},"description":"Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.","url":"https:\/\/binaryworld.net\/blogs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts\/280"}],"collection":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/comments?post=280"}],"version-history":[{"count":0,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts\/280\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/media\/606"}],"wp:attachment":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/media?parent=280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/categories?post=280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/tags?post=280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}