I am getting date value from database like "2013-02-27 06:06:30" using StringTokenizer I will get time separately like below
String startTime = "2013-02-27 06:06:30"; StringTokenizer token = new StringTokenizer(startTime); String date1 = token.nextToken(); String time1 = token.nextToken();
and in time1 I am getting the result 06:06:30,
Can I re-store it in another variable of type String as follows?
String displayValue = "06:06 AM";
And if time1 variable has the value of
String time = 16:00:00;
then it should be converted to:
String displayValue = "04:00 PM";
There are two patterns that we can use in SimpleDateFormat to display time. Pattern “hh:mm aa” and “HH:mm aa”, here HH is used for 24 hour format without AM/PM and the hh is used for 12 hour format with AM/PM. aa – AM/PM marker. In this example we are displaying current date and time with AM/PM marker.
Tips: To convert hh:mm:ss time format to minutes: =((HOUR(A2)*60)+MINUTE(A2)+(SECOND(A2)/60)); To convert hh:mm:ss time format to seconds: =HOUR(A2)*3600 + MINUTE(A2)*60 + SECOND(A2).
Try this..
Date dt = new Date(date1); SimpleDateFormat sdf = new SimpleDateFormat("hh:mm aa"); String time1 = sdf.format(dt);
I got answer just doing like this.
startTime = "2013-02-27 21:06:30"; StringTokenizer tk = new StringTokenizer(startTime); String date = tk.nextToken(); String time = tk.nextToken(); SimpleDateFormat sdf = new SimpleDateFormat("hh:mm:ss"); SimpleDateFormat sdfs = new SimpleDateFormat("hh:mm a"); Date dt; try { dt = sdf.parse(time); System.out.println("Time Display: " + sdfs.format(dt)); // <-- I got result here } catch (ParseException e) { e.printStackTrace(); }
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With