Date operations

[SAR]

Hi
I need to convert a string to Date to build a query. Following are the values which i am recieving from front end

String date = 06/21/2010

while running the query on database table the date should be in following format


2010-06-21 18:18:02.732

Here is what i tried
Date = Date.replace('/','-');
String pattern = "yyyy-MM-dd";
SimpleDateFormat sdf = new SimpleDateFormat(pattern);

String dateStartRange = sdf.format(sdf.parse(Date))
+ " 00:00:00.0";
String dateEndRange = sdf.format(sdf.parse(Date))
+ " 23:59:59.0";


Function call sdf.format(sdf.parse(Date)) is not returning correct values

please advise

[Norm]

not returning correct values

Please show the actual code and what was returned.

[SAR]

The value of dateStartRange in statement
String dateStartRange = sdf.format(sdf.parse(Date))
+ " 00:00:00.0"; is returned as 0013-03-02 00:00:00.0

[Norm]

Please show the actual code and what was returned.

Sorry, I meant the all of the code showing the input, formatting and output.
You've left off the definition and values of sdf and Date.
Something that can be compiled and executed to show the problem.

[SAR]

Hi Norm

import java.text.SimpleDateFormat;
import java.util.Date;

String Date = "06/21/2010";
Date = Date.replace('/','-');
String pattern = "yyyy-MM-dd";
SimpleDateFormat sdf = new SimpleDateFormat(pattern);

String dateStartRange = sdf.format(sdf.parse(Date))
+ " 00:00:00.0";
String dateEndRange = sdf.format(sdf.parse(Date))
+ " 23:59:59.0";
****************************
I am expecting the value of dateStartRange = 2010-06-21 00:00:00.0 and value of dateEndRange = 2010-06-21 23:59:59.0

But these are coming out to be
dateStartRange= "0013-03-02 00:00:00.0"
dateEndRange= "0013-03-02 23:59:59.0"

[Norm]

You need separate patterns for the input and for the output.

[SAR]

hmm i am not sure i understand this, how can i set separate patterns for inpit and output

[Norm]

One to parse the input and one to format the output

[SAR]

Thnx that solved my problem

[Tolls]

You shouldn't be using Strings for Dates in a query anyway.
That's Bad Practice...unless the date in the db isn't a DATE, which is almost always itself a mistake.