id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
3426	mythrename.pl can't rename	anonymous	stuartm	"I believe this has to do with converting between Unix time.  From one particular example, the script receives a starttime as 1178350606.  This converts to '2007-05-06 00:36:46' in FROM_UNIXTIME().  The database record for that particular recording shows as '2007-05-05 00:34:00'.  In my database query, the database is showing the date already formatted, not as a Unix-style timestamp.  This is stated on the mysql website:
Note: If you use UNIX_TIMESTAMP() and FROM_UNIXTIME() to convert between TIMESTAMP values and Unix timestamp values, the conversion is lossy because the mapping is not one-to-one in both directions. For details, see the description of the UNIX_TIMESTAMP() function.  Could this be the issue?"	defect	closed	minor	unknown	contrib	unknown	low	fixed			0