UPDATE temptime SET timetime = + (RTIME(INT(SGET(timetext,2,1)),INT(SGET(timetext,2,4)),0,0))
This assumes that you texts are truly in 00:00 format Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Castanaro, Bob Sent: Friday, November 14, 2008 4:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Convert text to time List, Having a brain freeze. Is there a way to convert text data values to time in a table. For example, I have two fields, one is time one is text data type. I need to do some math on this, and cannot remember if you can change the data type from text to time. The data is in time format 00:00 in both columns. Any ideas? Thanks Bob C Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [EMAIL PROTECTED] [cid:[email protected]]
