Hi,
In one of my tables there are two columns with data of TIMESTAMP(14) type. Now I need to make a query to get the AVERAGE, MINIMUM and MAXIMUM of the difference between them. That's OK. But it returns a number (I don't even know what exactly that is, the number of seconds, the number of seconds from a certain point of time or what). What I really want is to display the data formatted to the conventional number_of_days, hh:mm:ss format. Is it possible? Has anyone done anything similar? Please help me!!!
Thanks, Akos
In one of my tables there are two columns with data of TIMESTAMP(14) type. Now I need to make a query to get the AVERAGE, MINIMUM and MAXIMUM of the difference between them. That's OK. But it returns a number (I don't even know what exactly that is, the number of seconds, the number of seconds from a certain point of time or what). What I really want is to display the data formatted to the conventional number_of_days, hh:mm:ss format. Is it possible? Has anyone done anything similar? Please help me!!!
Thanks, Akos