got a table which has a time field hhhh:mm:ss (dont ask why hhhh as i dont care and it does not make a difference)
doing a mysql statement as this
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(totaltime))) as ttotal from scostudentscores where(rolcourseid='BCLIB')
this basically totals up the time where a field has a certain value... GREAT and i get the correct result of 00:04:00
when i response.write the field into ASP web page i get the current date..... eg 27/04/2005
CONFUSED I AM.....
have tried doing a hour(variable), minute(variable) etc and it gives nme 0:0:0
the session.lcid is for UK which is 2057... the server the website is running on has the correct timezone... so i need assistance...
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…