Time conversion function

[artistlikeu]

I have time column in my database whose data type is "time" i.e 00:00:00.
In python i make a query and get this column as string.
I want this time only in seconds i.e. integers.

I want a python function which converts time like this into seconds (integers).
Presently i am writing formula in python But Is there any function which serves this purpose????
What i have to do???

[bvdet]

I have time column in my database whose data type is "time" i.e 00:00:00.
In python i make a query and get this column as string.
I want this time only in seconds i.e. integers.

I want a python function which converts time like this into seconds (integers).
Presently i am writing formula in python But Is there any function which serves this purpose????
What i have to do???

This simple function will return the time in seconds as an integer:

def time_in_seconds(time_str):
    str_list = (time_str.split(":"))
    return int(str_list[0])*3600 + int(str_list[1])*60 + int(str_list[2])

[artistlikeu]

Hi all,
i do not want to define time class....... i want to write or add a function for time that convers time into seconds and give me integers

cheers...

This simple function will return the time in seconds as an integer:

def time_in_seconds(time_str):
    str_list = (time_str.split(":"))
    return int(str_list[0])*3600 + int(str_list[1])*60 + int(str_list[2])

[bartonc]

Hi all,
i do not want to define time class....... i want to write or add a function for time that convers time into seconds and give me integers

cheers...

This defines a function, not a class. Look at the docs [Global Module Index -> time] for time related classes.

If you are using a SQL database, I can help you get the second from there.

[bartonc]

This simple function will return the time in seconds as an integer:

def time_in_seconds(time_str):
str_list = (time_str.split(":"))
return int(str_list[0])*3600 + int(str_list[1])*60 + int(str_list[2])

Thanks for hanging around. I have ideas for making this forum a place where more expert topics are discussed.
Stick around,
Barton