MySQL - Time type

[rmatthew]

I have a query that uses the following:

sec_to_time(62)

Return from mysql is 00:01:02
Return from data provider is 12:01:02 AM

I have tried to cast in the following manner.

cast(sec_to_time(62) as time) but it only returns the same (12:01:02 AM)

is there a way to get into HHH:MM:SS format from here? I cannot find a MySQL command that will do it.

Thanks in advance...

 

[archer_coal]

RE

TIME as type when creating the table
CURTIME( ) to set or retrieve the current time is that what you needed?
TIME is HH:MM:SS

 

[rmatthew]

yes, but can you not cast the value (the value is a calculation on two fields)?