Spring Data Jpa : java 8 instant comparaisonHow to get the current time in YYYY-MM-DD HH:MI:Sec.Millisecond format in Java?Java string to date conversionWhat is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?Spring Data-JPA versus JPA: What's the difference?Filtering database rows with spring-data-jpa and spring-mvcWhat is the difference between Hibernate and Spring Data JPASpring JPA merge parent entity from new child entityQuery on Date only with Spring Boot Data JPA / Java 8 Instant?Spring batch chicken and egg: transient JPA referenceSpring Boot JPA@CreatedDate @LastModifiedDate not being populated when saving the object

Why in book's example is used 言葉(ことば) instead of 言語(げんご)?

Why did the EU agree to delay the Brexit deadline?

Can someone explain how this makes sense electrically?

Varistor? Purpose and principle

Confusion on Parallelogram

Why does Async/Await work properly when the loop is inside the async function and not the other way around?

If a character with the Alert feat rolls a crit fail on their Perception check, are they surprised?

Do the concepts of IP address and network interface not belong to the same layer?

What is this type of notehead called?

Transformation of random variables and joint distributions

What is the gram­mat­i­cal term for “‑ed” words like these?

Is it possible to use .desktop files to open local pdf files on specific pages with a browser?

Is camera lens focus an exact point or a range?

How do I implement a file system driver driver in Linux?

Should I install hardwood flooring or cabinets first?

A social experiment. What is the worst that can happen?

THT: What is a squared annular “ring”?

Does the Mind Blank spell prevent the target from being frightened?

What does the Rambam mean when he says that the planets have souls?

Greatest common substring

Open a doc from terminal, but not by its name

Did US corporations pay demonstrators in the German demonstrations against article 13?

Why is Arduino resetting while driving motors?

How do ground effect vehicles perform turns?



Spring Data Jpa : java 8 instant comparaison


How to get the current time in YYYY-MM-DD HH:MI:Sec.Millisecond format in Java?Java string to date conversionWhat is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?Spring Data-JPA versus JPA: What's the difference?Filtering database rows with spring-data-jpa and spring-mvcWhat is the difference between Hibernate and Spring Data JPASpring JPA merge parent entity from new child entityQuery on Date only with Spring Boot Data JPA / Java 8 Instant?Spring batch chicken and egg: transient JPA referenceSpring Boot JPA@CreatedDate @LastModifiedDate not being populated when saving the object













1















In my app i need to search an order by his creation_date.
In my entity, the type of the creationDate field is java.time.Instant.



In my class ManualOrderSpecification i need to check the creation_date.



I would like to compare the date of creation without the hours or with the same hour (0 hour for example).



My code :



 if (searchBean.getCreatedDate() != null) 
Instant createdInstantFromForm = ZonedDateTime.of(searchBean.getCreatedDate(), LocalTime.of(0, 0, 0, 0), ZoneId.systemDefault()).toInstant();
p.getExpressions().add(criteriaBuilder.equal(root.get(ManualOrder_.createdDate), createdInstantFromForm ));



Of course it doesn't work because i compare the same date but with different hours, 0 hour to another hours.
How can i force to compare to a localdate
or
can i force to 0 hours the root.get(ManualOrder_.createdDate) attribute ?



Many thanks










share|improve this question




























    1















    In my app i need to search an order by his creation_date.
    In my entity, the type of the creationDate field is java.time.Instant.



    In my class ManualOrderSpecification i need to check the creation_date.



    I would like to compare the date of creation without the hours or with the same hour (0 hour for example).



    My code :



     if (searchBean.getCreatedDate() != null) 
    Instant createdInstantFromForm = ZonedDateTime.of(searchBean.getCreatedDate(), LocalTime.of(0, 0, 0, 0), ZoneId.systemDefault()).toInstant();
    p.getExpressions().add(criteriaBuilder.equal(root.get(ManualOrder_.createdDate), createdInstantFromForm ));



    Of course it doesn't work because i compare the same date but with different hours, 0 hour to another hours.
    How can i force to compare to a localdate
    or
    can i force to 0 hours the root.get(ManualOrder_.createdDate) attribute ?



    Many thanks










    share|improve this question


























      1












      1








      1








      In my app i need to search an order by his creation_date.
      In my entity, the type of the creationDate field is java.time.Instant.



      In my class ManualOrderSpecification i need to check the creation_date.



      I would like to compare the date of creation without the hours or with the same hour (0 hour for example).



      My code :



       if (searchBean.getCreatedDate() != null) 
      Instant createdInstantFromForm = ZonedDateTime.of(searchBean.getCreatedDate(), LocalTime.of(0, 0, 0, 0), ZoneId.systemDefault()).toInstant();
      p.getExpressions().add(criteriaBuilder.equal(root.get(ManualOrder_.createdDate), createdInstantFromForm ));



      Of course it doesn't work because i compare the same date but with different hours, 0 hour to another hours.
      How can i force to compare to a localdate
      or
      can i force to 0 hours the root.get(ManualOrder_.createdDate) attribute ?



      Many thanks










      share|improve this question
















      In my app i need to search an order by his creation_date.
      In my entity, the type of the creationDate field is java.time.Instant.



      In my class ManualOrderSpecification i need to check the creation_date.



      I would like to compare the date of creation without the hours or with the same hour (0 hour for example).



      My code :



       if (searchBean.getCreatedDate() != null) 
      Instant createdInstantFromForm = ZonedDateTime.of(searchBean.getCreatedDate(), LocalTime.of(0, 0, 0, 0), ZoneId.systemDefault()).toInstant();
      p.getExpressions().add(criteriaBuilder.equal(root.get(ManualOrder_.createdDate), createdInstantFromForm ));



      Of course it doesn't work because i compare the same date but with different hours, 0 hour to another hours.
      How can i force to compare to a localdate
      or
      can i force to 0 hours the root.get(ManualOrder_.createdDate) attribute ?



      Many thanks







      date spring-data-jpa java.time.instant






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Mar 7 at 9:06









      Ole V.V.

      31.3k63956




      31.3k63956










      asked Mar 6 at 9:53









      loicloic

      136115




      136115






















          0






          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55020110%2fspring-data-jpa-java-8-instant-comparaison%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55020110%2fspring-data-jpa-java-8-instant-comparaison%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Save data to MySQL database using ExtJS and PHP [closed]2019 Community Moderator ElectionHow can I prevent SQL injection in PHP?Which MySQL data type to use for storing boolean valuesPHP: Delete an element from an arrayHow do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?How to get a list of MySQL user accountsHow Do You Parse and Process HTML/XML in PHP?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?Why shouldn't I use mysql_* functions in PHP?

          Compiling GNU Global with universal-ctags support Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Tags for Emacs: Relationship between etags, ebrowse, cscope, GNU Global and exuberant ctagsVim and Ctags tips and trickscscope or ctags why choose one over the other?scons and ctagsctags cannot open option file “.ctags”Adding tag scopes in universal-ctagsShould I use Universal-ctags?Universal ctags on WindowsHow do I install GNU Global with universal ctags support using Homebrew?Universal ctags with emacsHow to highlight ctags generated by Universal Ctags in Vim?

          Add ONERROR event to image from jsp tldHow to add an image to a JPanel?Saving image from PHP URLHTML img scalingCheck if an image is loaded (no errors) with jQueryHow to force an <img> to take up width, even if the image is not loadedHow do I populate hidden form field with a value set in Spring ControllerStyling Raw elements Generated from JSP tagds with Jquery MobileLimit resizing of images with explicitly set width and height attributeserror TLD use in a jsp fileJsp tld files cannot be resolved