DateTime math troubles

I am attempting to calculate a time difference between two DateTime objects. The first object is system.date.now(). The second object is giving me trouble. the second object is taken from a row in a dataset that was populated with a SQL query to a MySQL database.

current_datetime = system.date.now()
event_set_time = tbl.getValueAt(selrow, 'IG_Event_Set_time')

The customer wants to know the time difference in minutes (since_reset_time).
Something along the order of:

system.date.minutesBetween(current_datetime, event_set_time)

The event_set_time DateTime can actually be up to 10 days prior to current_datetime. The customer wants the since_reset_time in minutes. Every attempt I have made to calculate this number has resulted in some sort of datatype error.

What is the datatype of that table column ?

You can do tbl.getColumnType(tbl.getColumnIndex('IG_Event_Set_time')).

If the type of your column is string,

you'll have to convert the time into date, one way is as below:

from java.util import Calendar
from java.text import SimpleDateFormat

Date format will vary.
time = SimpleDateFormat('yyyy-MM-dd HH:mm:ss').parse(time)

If the date format is date,
Can you post the Error ?

Hi. The column in mysql is a DATETIME. The column in the dataset is Date.
This is the closest I have come to getting this to work:

#			Calculate Event Since Set Time
			since_set_time_format = str(system.date.minutesBetween(event_set_time_raw,current_time_raw))		
#			since_set_time_format = current_datetime - event_set_datetime
			since_set_str = str(since_set_time_format)

Capture
I am pretty sure there are more than 465 minutes between the two Datetimes

Amm, Something’s not right. I just checked mine with two different dates from SQL.

Can you please

print event_set_time_raw
print type(event_set_time_raw)
print current_time_raw
print type(current_time_raw)

Why not just use system.date.parse?

That’s right !! Sometime I can only think non straightforward ways of solving problems

I shall try

101   print event_set_time_raw
102   print type(event_set_time_raw)
103   print current_time_raw
104   print type(current_time_raw)

returns:
Traceback (most recent call last):
File “event:mouseReleased”, line 2, in
File “”, line 102, in ShowDetails
TypeError: ‘unicode’ object is not callable

I shall try:
‘’’
current_time_parse = system.date.parse(current_time_raw)

event_set_time_raw = tbl.getValueAt(selrow, ‘IG_Event_Set_Time’)
event_set_time_parse = system.date.parse(event_set_time_raw)

		since_set_time_test	= str(system.date.minutesBetween(event_set_time_parse,current_time_parse))
Uploading seems to be not working for me today. The result is:
Set                     2020-06-04 05:51:07 
Since Set (min)         1021

I ran the script at     2020-07-04 07:28:03