Converting string to java.util.date

Sri_Haran · July 22, 2022, 5:53am

Hello All,
I’m in need of to compare a time interval between two time_stamp
where one from database and for another i use system.time.now() function
then to calculate time difference i used function called system.date.minutesBetween()
when i passed the 2 arg inside this function the first arg from database is showing like
TypeError: minutesBetween(): 1st arg can’t be coerced to java.util.Date
Any suggestion would be appreciated
Thanks

JordanCClark · July 22, 2022, 9:55am

If it’s coming in as a string, try using system.date.parse().

lrose · July 22, 2022, 12:19pm

What is the column type in the database table where the date is stored?

Sri_Haran · July 23, 2022, 6:47am

it was timestamp without timezone

JordanCClark · July 23, 2022, 9:53am

And it’s coming in as a string? Or are you coercing it to a string?

What datatype do you get when you use something like print type(myTimeStampValue)?

Sri_Haran · July 28, 2022, 9:59am

Hi @JordanCClark,
Sorry for the delay in reply the datatype was not a string it’s an arrayList

Thanks & Regards,
Sri

JordanCClark · July 28, 2022, 10:01am

Well, that’s because you grabbed it as a list.

What about type(sri[0]) to get the type of the first value of the list?

Sri_Haran · July 28, 2022, 10:03am

Hey sorry @JordanCClark,
it was <type ‘java.util.Date’>
Regards,
Sri

JordanCClark · July 28, 2022, 10:04am

No worries, Sri.

Huh. Well, there shouldn't be an issue with minutesBetween() then.

Sri_Haran · July 28, 2022, 10:10am

That’s fine man i used some other methods actually my requirement was changed from checking DB time to current time
Thanks
Sri