Re: HELP PLEASE!
DOES ANY ONE KNOW WHY THE OUTCOME IS DIFFERENT FOR TIME_ENROLLED ?
FOR EXAMPLE , IN THE INSERT VALUES I HAVE "2011-08-01" BUT THE OUTCOME IS TOTALLY DIFFERENT IT SHOWS "1985-07-14"
THIS IS MY CODE:
INSERT INTO STUDENT VALUES
('JO100','Jones','Tammy','R','1817 Eagleridge Circle','Tallahasse','FL','32811','7155559876','SR','850714','8891',1,CAST(DATE_ADD(CURDATE(), INTERVAL (UNIX_TIMESTAMP(CURDATE()) - UNIX_TIMESTAMP('2011-08-01')) SECOND) AS DATE));
TABLE:
TIME_ENROLLED INTEGER(255)
THANKS
Subject
Written By
Posted
November 01, 2014 05:32AM
Re: HELP PLEASE!
November 02, 2014 04:08PM
November 02, 2014 04:32PM
November 02, 2014 06:00PM
November 03, 2014 05:17AM
November 03, 2014 09:58AM
November 03, 2014 11:54AM
November 03, 2014 12:15PM
November 03, 2014 12:49PM
November 03, 2014 02:09PM