Cannot convert date type yyyy-MM-dd to LocalDateTime in Java

I am getting a date input from the user which is of type yyyy-MM-dd (e.g: 2023-02-26). I am trying to convert it to LocalDateTime format so that I will get something like this format, 2023-02-26 22:03:05.034981

I have tried examples available online like below.

DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
LocalDateTime createdDate =  LocalDateTime.parse(projectSearchCriteria.getCreatedDate(), formatter);

But getting below error

Caused by: java.time.format.DateTimeParseException: Text '2023-02-26' could not be parsed at index 10

Any ideas on how to get this issue fixed.

====================== Additional Info ===================

I have converted so that the string input is now parsed to a LocalDate

But still it gives the below error

This is because I have the LocalDateTime format in the database

Is there any specific way how I can use the 2023-02-26 to find something like 2023-02-26 22:03:05.034981 in the database?

tl;dr

LocalDateTime.of( 
    LocalDate.parse( "2023-02-26" ) , 
    LocalTime.parse( "22:03:05.034981" ) 
)

Details

> LocalDateTime format so that I will get something like this format, 2023-02-26 22:03:05.034981

You are confusing date-time objects with formatted text. A date-time object is not text, and has no format.

A date-time class can be used to parse a piece of text, extract meaning, and instantiate a date-time object. But the original text is discarded. Date-time objects and String objects are entirely separate and distinct.

>I am getting a date input from the user which is of type yyyy-MM-dd (e.g: 2023-02-26)

So parse that input text as a LocalDate, a date-only value without a time-of-day and without the context of a time zone or offset-from-UTC.

LocalDate ld = LocalDate.parse( "2023-02-26" ) ;

Apparently you want to attach to that date a particular time-of-day (for reasons you do not describe clearly). First parse your text input for that time-of-day.

LocalTime lt = LocalTime.parse( "22:03:05.034981" ) ;

👉 Combine the two into a LocalDateTime.

LocalDateTime ldt = LocalDateTime.of( ld , lt ) ;

>Is there any specific way how I can use the 2023-02-26 to find something like 2023-02-26 22:03:05.034981 in the database?

Do you mean search the database for that exact date and time?

First, be sure the database table column is of a data type akin to the SQL data type TIMESTAMP WITHOUT TIME ZONE. Verify the WITHOUT part, rather than WITH.

Then write your SQL query with the ? syntax for passing a value via a prepared statement.

String sql =
    """
    SELECT * 
    FROM some_table_
    WHERE date_time_ = ?
    ;
    """
;

Query.

myPreparedStatement.setObject( 1 , ldt ) ;

Retrieve found rows.

LocalDateTime ldt = myResultSet.getObject( … , LocalDateTime.class ) ;

By the way… Be aware that a LocalDateTime object is ambiguous and indefinite. Without the context of a zone or offset, a LocalDateTime object cannot represent a moment, is not a point on the timeline.