How to Auto Calculated time in SQL Database Select Column

paingsoe thu

my database table is tableone.
for example......

INSERT INTO tableone(Name,EntryDate,ServiceDate) VALUES('MG MG', '1/1/2012' , ' ' )
INSERT INTO tableone(Name,EntryDate,ServiceDate) VALUES('KO KO', '1/3/2012' , ' ' )
INSERT INTO tableone(Name,EntryDate,ServiceDate) VALUES('John', '1/2/2012' , ' ' )

Now,We inserted data to tableone but ServiceDate Column is empty.This ServiceDate Column is
Now time(CURDATE)-EntryDateColumn values Inserted and Update ServiceDate Column.This ServiceDate Column is ever auto calculation and auto update inserted to ServiceDate Column.Please Help Me...Thank You...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

paingsoe thu13y ago
No inserted to EntryDate Column.This EntryDate Column is Auto Calculation and Update Column.

DateTime t1 = DateTime.Now;
DateTime t2 = Convert.ToDateTime(dateTimePicker1.Text);
DateTime Calculation = t1 - t2;

UPDATE tableone SET EntryDate = Calculation

Are you understand brother.?
Jaganathan Bantheswaran13y ago
Should we insert time or date into ServiceDate?