{"id":510,"date":"2007-07-27T09:33:54","date_gmt":"2007-07-27T09:33:54","guid":{"rendered":"http:\/\/osmeusapontamentos.com\/?p=510"},"modified":"2007-07-27T09:33:54","modified_gmt":"2007-07-27T09:33:54","slug":"sql-convert-date-format","status":"publish","type":"post","link":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/","title":{"rendered":"sql convert date format"},"content":{"rendered":"<p>Eu sou um bocado paran\u00f3ico em rela\u00e7\u00e3o \u00e0s convers\u00f5es entre tipos de dados, provavelmente porque tive que conviver muito tempo com pessoas que faziam coisas fant\u00e1sticas como gravar datas ou n\u00fameros em campos de texto.<br \/>\nNo entanto h\u00e1 situa\u00e7\u00f5es em que temos mesmo que fazer este tipo de convers\u00f5es, normalmente para gerar outputs, e um dos casos mais comuns \u00e9 converter uma data para uma string.<br \/>\nEsta opera\u00e7\u00e3o aparentemente trivial levanta um conjunto de quest\u00f5es que t\u00eam essencialmente a ver com o formato que cada l\u00edngua tem para a data, por exemplo quantos n\u00fameros considerar para o ano, dois ou quatro? qual o formato da data, dd-mm-aaaa, aaaa-mm-dd, mm-dd-aaaa? e qual o separador &#8216;\/&#8217;, &#8216;-&#8216;, &#8216;.&#8217;?<br \/>\nFelizmente o sql server j\u00e1 inclui o conjunto de convers\u00f5es mais habitual que listo em baixo.<br \/>\n<font color=\"#ff00ff\" size=\"2\">convert<\/font><font color=\"#808080\" size=\"2\">(<\/font><font color=\"#0000ff\" size=\"2\">varchar<\/font><font color=\"#808080\" size=\"2\">(<\/font><font size=\"2\">50<\/font><font color=\"#808080\" size=\"2\">),<\/font><font size=\"2\"> <\/font><font color=\"#ff00ff\" size=\"2\">getdate<\/font><font color=\"#808080\" size=\"2\">(),<\/font><font size=\"2\"> opcao<\/font><font color=\"#808080\" size=\"2\">)<\/font><\/p>\n<ul>   <font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 0 <\/font><font color=\"#008000\" size=\"2\">&#8212; Aug 27 2007 10:20AM<\/font><\/li>\n<p><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 1 <\/font><font color=\"#008000\" size=\"2\">&#8212; 08\/27\/07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 2 <\/font><font color=\"#008000\" size=\"2\">&#8212; 07.08.27<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 3 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27\/08\/07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 4 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27.08.07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 5 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27-08-07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 6 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27 Aug 07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 7 <\/font><font color=\"#008000\" size=\"2\">&#8212; Aug 27, 07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 8 <\/font><font color=\"#008000\" size=\"2\">&#8212; 10:17:36<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 9 <\/font><font color=\"#008000\" size=\"2\">&#8212; Aug 27 2007 10:18:11:090AM<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 10 <\/font><font color=\"#008000\" size=\"2\">&#8212; 08-27-07<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 11 <\/font><font color=\"#008000\" size=\"2\">&#8212; 07\/08\/27<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 12 <\/font><font color=\"#008000\" size=\"2\">&#8212; 070827<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 13 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27 Aug 2007 10:22:46:000<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 14 <\/font><font color=\"#008000\" size=\"2\">&#8212; 10:22:54:530<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 100 <\/font><font color=\"#008000\" size=\"2\">&#8212; Aug 27 2007 10:20AM<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 101 <\/font><font color=\"#008000\" size=\"2\">&#8212; 08\/27\/2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 102 <\/font><font color=\"#008000\" size=\"2\">&#8212; 2007.08.27<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 103 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27\/08\/2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 104 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27.08.2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 105 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27-08-2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 106 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27 Aug 2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 107 <\/font><font color=\"#008000\" size=\"2\">&#8212; Aug 27, 2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 108 <\/font><font color=\"#008000\" size=\"2\">&#8212; 10:17:36<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 109 <\/font><font color=\"#008000\" size=\"2\">&#8212; Aug 27 2007 10:18:11:090AM<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 110 <\/font><font color=\"#008000\" size=\"2\">&#8212; 08-27-2007<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 111 <\/font><font color=\"#008000\" size=\"2\">&#8212; 2007\/08\/27<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 112 <\/font><font color=\"#008000\" size=\"2\">&#8212; 20070827<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 113 <\/font><font color=\"#008000\" size=\"2\">&#8212; 27 Aug 2007 10:22:46:000<\/font><\/li>\n<p><\/font><\/font> <font size=\"2\"><font size=\"2\"><\/p>\n<li>opcao <font color=\"#808080\" size=\"2\">=<\/font><font size=\"2\"> 114 <\/font><font color=\"#008000\" size=\"2\">&#8212; 10:22:54:530<\/font><\/li>\n<p><\/font><\/font><\/ul>\n<p>J\u00e1 agora se quisermos que os nomes dos meses e\/ou dias da semana apare\u00e7am em portugu\u00eas (e estivermos com a default language em ingl\u00eas) teremos que primeiro incluir a instru\u00e7\u00e3o set language portuguese<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Eu sou um bocado paran\u00f3ico em rela\u00e7\u00e3o \u00e0s convers\u00f5es entre tipos de dados, provavelmente porque tive que conviver muito tempo com pessoas que faziam coisas fant\u00e1sticas como gravar datas ou n\u00fameros em campos de texto. No entanto h\u00e1 situa\u00e7\u00f5es em que temos mesmo que fazer este tipo de convers\u00f5es, normalmente para gerar outputs, e um [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[538,611],"class_list":["post-510","post","type-post","status-publish","format-standard","hentry","category-ler-ver-ouvir-passear","tag-programar","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>sql convert date format - Os Meus Apontamentos<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"sql convert date format - Os Meus Apontamentos\" \/>\n<meta property=\"og:description\" content=\"Eu sou um bocado paran\u00f3ico em rela\u00e7\u00e3o \u00e0s convers\u00f5es entre tipos de dados, provavelmente porque tive que conviver muito tempo com pessoas que faziam coisas fant\u00e1sticas como gravar datas ou n\u00fameros em campos de texto. No entanto h\u00e1 situa\u00e7\u00f5es em que temos mesmo que fazer este tipo de convers\u00f5es, normalmente para gerar outputs, e um [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Os Meus Apontamentos\" \/>\n<meta property=\"article:published_time\" content=\"2007-07-27T09:33:54+00:00\" \/>\n<meta name=\"author\" content=\"Vitor Silva\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@vitorsilva\" \/>\n<meta name=\"twitter:site\" content=\"@vitorsilva\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vitor Silva\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/\"},\"author\":{\"name\":\"Vitor Silva\",\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/#\\\/schema\\\/person\\\/d508df9c3ffc8b4e64a18dbf0ba18dd8\"},\"headline\":\"sql convert date format\",\"datePublished\":\"2007-07-27T09:33:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/\"},\"wordCount\":274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/#\\\/schema\\\/person\\\/d508df9c3ffc8b4e64a18dbf0ba18dd8\"},\"keywords\":[\"programar\",\"sqlserver\"],\"articleSection\":[\"Ler\\\/ Ver\\\/ Ouvir\\\/ Passear\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/\",\"url\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/\",\"name\":\"sql convert date format - Os Meus Apontamentos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/#website\"},\"datePublished\":\"2007-07-27T09:33:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/index.php\\\/2007\\\/07\\\/27\\\/sql-convert-date-format\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/osmeusapontamentos.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"sql convert date format\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/#website\",\"url\":\"https:\\\/\\\/osmeusapontamentos.com\\\/\",\"name\":\"Os Meus Apontamentos\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/#\\\/schema\\\/person\\\/d508df9c3ffc8b4e64a18dbf0ba18dd8\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/osmeusapontamentos.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/osmeusapontamentos.com\\\/#\\\/schema\\\/person\\\/d508df9c3ffc8b4e64a18dbf0ba18dd8\",\"name\":\"Vitor Silva\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g\",\"caption\":\"Vitor Silva\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/vitormrsilva\",\"https:\\\/\\\/x.com\\\/vitorsilva\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"sql convert date format - Os Meus Apontamentos","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:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/","og_locale":"pt_PT","og_type":"article","og_title":"sql convert date format - Os Meus Apontamentos","og_description":"Eu sou um bocado paran\u00f3ico em rela\u00e7\u00e3o \u00e0s convers\u00f5es entre tipos de dados, provavelmente porque tive que conviver muito tempo com pessoas que faziam coisas fant\u00e1sticas como gravar datas ou n\u00fameros em campos de texto. No entanto h\u00e1 situa\u00e7\u00f5es em que temos mesmo que fazer este tipo de convers\u00f5es, normalmente para gerar outputs, e um [&hellip;]","og_url":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/","og_site_name":"Os Meus Apontamentos","article_published_time":"2007-07-27T09:33:54+00:00","author":"Vitor Silva","twitter_card":"summary_large_image","twitter_creator":"@vitorsilva","twitter_site":"@vitorsilva","twitter_misc":{"Escrito por":"Vitor Silva","Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/#article","isPartOf":{"@id":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/"},"author":{"name":"Vitor Silva","@id":"https:\/\/osmeusapontamentos.com\/#\/schema\/person\/d508df9c3ffc8b4e64a18dbf0ba18dd8"},"headline":"sql convert date format","datePublished":"2007-07-27T09:33:54+00:00","mainEntityOfPage":{"@id":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/"},"wordCount":274,"commentCount":0,"publisher":{"@id":"https:\/\/osmeusapontamentos.com\/#\/schema\/person\/d508df9c3ffc8b4e64a18dbf0ba18dd8"},"keywords":["programar","sqlserver"],"articleSection":["Ler\/ Ver\/ Ouvir\/ Passear"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/","url":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/","name":"sql convert date format - Os Meus Apontamentos","isPartOf":{"@id":"https:\/\/osmeusapontamentos.com\/#website"},"datePublished":"2007-07-27T09:33:54+00:00","breadcrumb":{"@id":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/osmeusapontamentos.com\/index.php\/2007\/07\/27\/sql-convert-date-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/osmeusapontamentos.com\/"},{"@type":"ListItem","position":2,"name":"sql convert date format"}]},{"@type":"WebSite","@id":"https:\/\/osmeusapontamentos.com\/#website","url":"https:\/\/osmeusapontamentos.com\/","name":"Os Meus Apontamentos","description":"","publisher":{"@id":"https:\/\/osmeusapontamentos.com\/#\/schema\/person\/d508df9c3ffc8b4e64a18dbf0ba18dd8"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/osmeusapontamentos.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":["Person","Organization"],"@id":"https:\/\/osmeusapontamentos.com\/#\/schema\/person\/d508df9c3ffc8b4e64a18dbf0ba18dd8","name":"Vitor Silva","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g","caption":"Vitor Silva"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/f81f58ad909e8a213ab0a690f6ed65e5c0e0e2274bf35ac49ff31d7988d483ce?s=96&d=mm&r=g"},"sameAs":["https:\/\/www.linkedin.com\/in\/vitormrsilva","https:\/\/x.com\/vitorsilva"]}]}},"_links":{"self":[{"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/posts\/510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/comments?post=510"}],"version-history":[{"count":0,"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/posts\/510\/revisions"}],"wp:attachment":[{"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/media?parent=510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/categories?post=510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/osmeusapontamentos.com\/index.php\/wp-json\/wp\/v2\/tags?post=510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}