2 replies to this topic

[sam_coder]

Hey Guys,

I have a date format coming in, and I'm uncertain the best way to ingest it with Java.

the date format looks like this.

2019-09-19T23:59:59-03:00

I get that it's Year, Month, Day, Hours, Minutes, Seconds
And I think the -03:00 is a GMT offset.

normally that is denoted like this:
-0300, is it not?

Should this be handled with a SimpleDateFormat, something like this?

new SimpleDateFormat("yyyy-MM-ddTHH:mm:ssZ");

or would something else be more appropriate?

Many Thanks!

[wim DC]

You gonna need single quotes around the 'T' to make the format work.

new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ssZ")

But then you're still left with the issue of having the unwanted semicolon at the timezone.

I guess it's easiest to just get rid of it manually.

dateString = dateString.substring(0, dateString.lastIndexOf(":")) + dateString.substring(dateString.lastIndexOf(":")+1);

[sam_coder]

Many thanks! Glad to know I wasn't too far off the mark! =)