search for: str_to_dat

...0.10*", "DATEDIFF(MAX(FROM_UNIXTIME(submit_time)),MIN(FROM_UNIXTIME(", "submit_time))) DAY FROM ",systems[iter],") ",sep="") if(QUERY_DATE=="Year") { usageAVGQuery<-paste("SELECT STR_TO_DATE(CONCAT(YEAR(FROM_UNIXTIME(dispatch_time)),'-01-01'),'%Y-%m-%d') AS date, AVG(cpu_seconds_user/total_time) AS time, AVG(num_cpus) AS AVG_CPUs, AVG(dispatch_time-end_time) AS AVG_job_length FROM ",systems[iter],usageDateClamp,"GROUP BY date;",sep="")...

i have a time field in my table. it is of varchar data type. i want compare the time between given times. my stored time format is 09:25:01 am. is there any way to compare my time field ? i don t have any idea about mysql STR_TO_DATE function.. will it be usefull for my above problem.. please help me up to try it out... -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails...

Hi, I have a complex SQL request to perform. I don''t want to manually do the whole query (find_by_sql) because of the complex joins, but I want to use MySQL functions, such as: Model.find(:all, :include => [../..], :conditions => ["(../..) AND YEAR(STR_TO_DATE(my_table.my_row,''%Y-%m-%d %H:%i:%s'')) = #{year})"], :select => [../..]) or Model.find(:all, :include => [../..], :conditions => ["(../..) AND YEAR(STR_TO_DATE(my_table.my_row,GET_FORMAT(DATETIME,''ISO''))) = #{...