Thanks for the feedback Martin. But the problem is that using the Perl equivalent of a time() function would provide the time on the machine running the daemon, which may not be the same machine as the database machine...
On Mon, 2010-03-08 at 00:11 +0100, Martin Fuchs wrote: > Hello Kristis Makris, > > I think the Mantis developers use int values to represent date values in the > PHP code (you may look in it for example here: > http://git.mantisforge.org/w/mantisbt.git?a=blob;f=core/date_api.php;hb=HEAD > ). So they just save this int values to the database. So a portable solution > for you would be to use the time() function > (http://www.php.net/manual/de/function.time.php) to query the current time > and save this value to the database. I think there must also be a comparable > Perl function you can use for this. > > Regards, > > Martin > > Am 07.03.2010 um 23:49 schrieb Kristis Makris: > > > Martin, unix_timestamp() is not available for postgres, or other > > databases. I am not sure what is the best way to handle this. I wonder > > how the Mantis developers handle it. > > > > On Sun, 2010-02-28 at 11:29 +0100, Martin Fuchs wrote: > >> Hello, > >> > >> there is now the new Mantis release 1.2.0: > >> > >> http://www.mantisbt.org/ > >> > >> > >> One change includes this: > >> > >> - Migrated away from DATETIME fields to integer timestamps for timezone > >> usage > >> > >> To become compatible to this new version, Scmbug should be changed to set > >> all date fields to unix_timestamp() instead of now() when inserting new > >> rows in the Mantis MySQL database. > >> > >> > >> Regards, > >> > >> Martin > >> _______________________________________________ > >> scmbug-users mailing list > >> [email protected] > >> http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users >
signature.asc
Description: This is a digitally signed message part
_______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
