SQL? – work with data from the clob::JSON column – issue SOLVED

ANSWER IS: — SELECT id, person_id, validity_date FROM public.product WHERE validity_date IS NULL;— UPDATE public.product SET validity_date = to_timestamp(clob::json->’validityDate’::text #>> ‘{}’, ‘yyyy-MM-dd’)::timestamp WHERE validity_date IS NULL; — SELECT id, person_id, validity_date FROM public.product WHERE person_id IS NULL;— UPDATE public.product SET person_id = clob::json->’personId’::text #>> ‘{}’ WHERE person_id IS NULL; —– Update sql request— SELECT id, …

SQL? – work with data from the clob::JSON column – issue SOLVED Read More »

Amigoscode Certificates

Terminal, Bash & VIM Essentials Git and Github Essentials Relational Database and SQL Essentials Spring Boot | React | AWS – Upload Images using AWS API Spring Security Spring Data MongoDB Getting Started with Spring Boot Functional Programming & Java Streams Getting Started with Java Getting Started with Python Master The Best Python IDE PyCharm …

Amigoscode Certificates Read More »

Microservices with Istio and IBM Cloud Kubernetes Service

In this course, I learned about the twelve-factor app methodology, microservices, and Istio foundational technologies to connect, manage, and secure those microservices. I learned how to put all of those technologies together in IBM Cloud Kubernetes Service. These cloud-native technologies are the essentials for building new apps for the cloud. Microservices are the building blocks …

Microservices with Istio and IBM Cloud Kubernetes Service Read More »