Convert integer to time........
-
Hi All, I want to save time from excel file to access database. excelsheet contain value 3.5 as time,this value I want to store into database datetime field as time. I don't know it is possible or not. If anyone know something please share with me. Thanks, Nagraj
-
Hi All, I want to save time from excel file to access database. excelsheet contain value 3.5 as time,this value I want to store into database datetime field as time. I don't know it is possible or not. If anyone know something please share with me. Thanks, Nagraj
if you know what does 3.5 means as a date you may do some calculations to convert it as a long number like 12032009 then manipulate with this number as a string. make like 12-03-2009 then convert it to date (use Cdate or Ctype) then save it to the database
Faris Madi Nothing Comes Easy (N.C.E.)
-
Hi All, I want to save time from excel file to access database. excelsheet contain value 3.5 as time,this value I want to store into database datetime field as time. I don't know it is possible or not. If anyone know something please share with me. Thanks, Nagraj
The Date time Field is going to store the date such as 3/3/2006 along with the time 12:00 AM. If I read this correctly 3.5 represents a measurment of time, 3 and a half hours, and not an actual Time of day. You should look at decimal data type or even a string.