MySQL Forums
Forum List  »  General

Sysdate Returrns Future Dates
Posted by: Luis Cavazos
Date: September 12, 2016 11:09AM

Hi,

I have a table with about 3500 records that are constantly been updated, I need to know the last time each record was updated, so I have a trigger to set the date in a field, but in some records it sets the date with 6 to 8 hours ahead.

CREATE DEFINER=`root`@`127.0.0.1` TRIGGER `db`.`mkpact_BINS`
BEFORE INSERT ON `mkpact`
FOR EACH ROW
BEGIN
set New.pacFecUltMov = Sysdate() ;
END

innodb_version 5.6.22
protocol_version 10
slave_type_conversions
version 5.6.22-log
version_comment MySQL Community Server (GPL)
version_compile_machine x86_64
version_compile_os Win64

Any Sugestions ?
Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Sysdate Returrns Future Dates
September 12, 2016 11:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.