Wednesday, November 16, 2011

MYSQl DATE ADD Nice Example

INSERT INTO `DB`.`tbl` (`id`, `filed1`, `filed2`, `filed2`, `start_date`, `expiry_date`, `status1`, `status2`, `status3`) VALUES (NULL, '2', '33', '8', NOW(), DATE_ADD(NOW(),INTERVAL 7 DAY), 'XXXX', 'Active', 'Active');

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home