paingsoe thu

paingsoe thu

  • NA
  • 15
  • 6.1k

How to Auto Calculated time in SQL Database Select Column

Nov 10 2013 11:40 PM
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...




Answers (2)