{"author_name":"shigemk2","image_url":null,"blog_title":"by shigemk2","title":"Error: Date '0000-00-00' is not recognized","published":"2023-10-11 20:23:14","blog_url":"https://www.shigemk2.com/","version":"1.0","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2023%2F10%2F11%2F202314\" title=\"Error: Date &#39;0000-00-00&#39; is not recognized - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","width":"100%","height":"190","provider_url":"https://hatena.blog","url":"https://www.shigemk2.com/entry/2023/10/11/202314","author_url":"https://blog.hatena.ne.jp/shigemk2/","categories":["snowflake"],"description":"Datetime(Timestamp)\u3082\u4e00\u7dd2\u3067 0000-00-00 00:00:00 \u306fnot recognized\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3002 DATE \u3068 TIMESTAMP \u306e\u30c7\u30fc\u30bf\u306e\u5834\u5408\u3001Snowflake\u306f\u30011582\u30689999\u306e\u9593\u306e\u5e74\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002Snowflake\u306f\u3001\u3053\u306e\u7bc4\u56f2\u5916\u306e\u6570\u5e74\u3092\u53d7\u3051\u5165\u308c\u307e\u3059\u304c\u3001 \u30b0\u30ec\u30b4\u30ea\u30aa\u66a6\u306e\u5236\u9650 \u306e\u305f\u3081\u30011582\u3088\u308a\u524d\u306e\u5e74\u306f\u907f\u3051\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 \u3068\u3044\u3046\u304b\u30011582-9999\u306e\u9593\u3058\u3083\u306a\u3044\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u306e\u3067\u30011582\u3088\u308a\u524d\u306e\u5e74\u306f\u5168\u90e8NG\u3067\u3059 docs.snowflake.com \u306e\u3067\u3001\u3053\u3093\u306a\u611f\u3058\u3067NULL_IF\u3092\u4f7f\u3063\u3066invalid\u306adate\u3084times\u2026"}