How to get the day, year, hours, min Individually from date format "yyyy-MM-dd'T'HH:mm:ss.SSSZ"?

Question

I am doing a programme that stores the present time and date in "yyyy-MM-dd'T'HH:mm:ss.SSSZ" this format. and I am storing it in database as a string. when i am collecting the data i need the individual values like day, year, min, seconds etc.. how can i do this?

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ");
String now = formatter.format(new Date());

Thank you,

How do you collecting the data, through database or java code? — pawelzieba, May 11 '12 at 13:10
Your question is unclear... you want them to be entered separately by the user or you want to separate them coming out of the database? — Barak, May 11 '12 at 13:11
i am storing the current date when user logins, but at the time of passing i want to split it.. — wolverine, May 11 '12 at 13:13
I found it easier to store everything in a DB as a "time in millis". — Joel Skrepnek, May 11 '12 at 13:24
@JoelSkrepnek is it possible to get the sec, fractional seconds from time mills? — wolverine, May 11 '12 at 13:25
The granularity is milliseconds. Pull the value out of the DB, create a Calendar object based on it, then use the 'get' method with the field set to MILLISECOND. — Joel Skrepnek, May 11 '12 at 13:32

score 32 · Answer 1 · answered May 11 '12 at 13:13

32

Just use parse instead of format :

String dateFromDB = "";
SimpleDateFormat parser = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ");
Date yourDate = parser.parse(dateFromDB);

And then you can can read any field you want using java.util.Date & Calendar API :

  Calendar calendar = Calendar.getInstance();
    calendar.setTime(yourDate);
    calendar.get(Calendar.DAY_OF_MONTH); //Day of the month :)
    calendar.get(Calendar.SECOND); //number of seconds
//and so on

I hope it fits your needs

answered May 11 '12 at 13:13

Estragon

1,462
11
12

it is showing the error 'java.text.ParseException: Unparseable date: 2012-05-11T18:25:55:250GMT' – wolverine May 11 '12 at 13:20
try to parse it just after the format. => parse the output of the format to see if the issue comes from the database. – Estragon May 11 '12 at 13:31
Anyway, try to parse the output of the format function. Also, make sure your date format is compliant with rules. – Estragon May 11 '12 at 13:36
i did not get this, "parse the output of the format function" – wolverine May 11 '12 at 13:37
sorry for my bad english. I mean try Date yourDate = parser.parse(parser.format(new Date()); – Estragon May 11 '12 at 13:39
It is working fine now for new date.. But not for my date entered? Y? – wolverine May 11 '12 at 13:44
Your date has : instead of . between 55 and 250. It may be the reason it doesnt work. But now you know you to parse the date :) – Estragon May 11 '12 at 14:06
@wolverine try this SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'hh:mm:ss:SZ"); – Amt87 May 12 '15 at 11:17

score 18 · Accepted Answer · edited Jun 22 '17 at 17:43

I'm suggesting that you store times in the DB as "timeInMillis". In my experience it simplifies code and it allows you to compare times values to eachother.

To store a time:

Calendar calendar = Calendar.getInstance(); // current time
long timeInMillis = calendar.getTimeInMillis();
mDb.saveTime (timeInMillis); // adjust this to work with your DB

To retrieve a time:

long timeInMillis = mDb.getTime();
Calendar calendar = Calendar.getInstance();
calendar.setTimeInMillis (timeInMillis);
int milliSeconds = calendar.get(MILLISECOND);
//etc

score 1 · Answer 3 · answered May 11 '12 at 13:12

1

There are these methods available to get the individual parts of a date

getDate()
getMinutes()
getHours()
getSeconds()
getMonth()
getTime()
getTimezoneOffset()
getYear()

answered May 11 '12 at 13:12

WingDev

137
5

These method was deprecated in API level 1. As of JDK version 1.1, To be replaced by using the following for ex: Calendar.get(Calendar.YEAR) - 1900. – this-Me Mar 17 '17 at 04:28

score 1 · Answer 4 · answered Dec 07 '13 at 01:15

1

Try using : int hour = Calendar.getInstance().get(Calendar.HOUR_OF_DAY);

Here,

Calendar.HOUR_OF_DAY gives you the 24-hour time.
Calendar.HOUR gives you the 12-hour time.

answered Dec 07 '13 at 01:15

Basher51

1,319
1
17
28

How to get the day, year, hours, min Individually from date format "yyyy-MM-dd'T'HH:mm:ss.SSSZ"?

4 Answers4

Linked

Related