0007844: date format in scripts

ID	Project	Category	View Status	Date Submitted	Last Update
0007844	mantisbt	feature	public	2007-03-20 19:00	2023-04-26 11:53

Reporter	andre_steffens	Assigned To	grangeway
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	won't fix
Product Version	1.1.0a2

Summary	0007844: date format in scripts
Description	It would be usefull to change the date format from unix_timestamp to a better format. At the moment the range is only from 1970-01-01 to 2038-01-19. Dates should be save and handle as "1970-01-01 09:30:25" = "Y-m-d H:i:s" with this change we wouldn't become problems in 2038!
Tags	No tags attached.

grangeway 2014-10-11 04:34 reporter ~0041554	We wouldn't store dates in format suggested. As we get closer to 2038, the solution here will probably be to only allow mantis to run with 64BIT versions of php, which extends the date to some point after we dead ;) If you are actually using dates in Mantis that are getting close to 2038 'now', please reopen this bug and we can look at whether there is scope to change the database storage from a INT to a 64bit BIGINT type type 'now'. I'm assuming however, that we don't need to worry about this for a few years.