Thread: TIMEDIFF issue

What a PIA...

Try this:

Code:

concat(floor(SEARCH_TIME/ 60),':',mod(SEARCH_TIME,60))

Originally Posted by jmurrayhead

What a PIA...

Try this:

Code:

concat(floor(SEARCH_TIME/ 60),':',mod(SEARCH_TIME,60))

This returns me 2:5:00 if i use SEARCH_TIME = 125
and surprisingly, its not returning me correct records

although 02:05:00 returns me correct reocrds

wtf

I'm out of ideas, short of simply converting that field to a datetime field...

Originally Posted by jmurrayhead

I'm out of ideas, short of simply converting that field to a datetime field...

i cant do that J

What about:

Code:

STR_TO_DATE(concat(floor(SEARCH_TIME/ 60),':',mod(SEARCH_TIME,60)), %h:%i)

I'll have to go now J......... i'll try tomorrow and tell you

thanx

Originally Posted by jmurrayhead

What about:

Code:

STR_TO_DATE(concat(floor(SEARCH_TIME/ 60),':',mod(SEARCH_TIME,60)), %h:%i)

bravo J, it worked with a little change

Code:

STR_TO_DATE(concat(floor(SEARCH_TIME/ 60),':',mod(SEARCH_TIME,60)), '%H:%i')

Thanx a lot man

excellent, glad it worked out for you