0005918: Database: Moving from Date/Time field to UnixTime Format

ID	Project	Category	View Status	Date Submitted	Last Update

0005918	MMW v4	Other	public	2009-08-25 02:19	2010-12-12 03:48

Reporter	peke	Assigned To
Priority	none	Severity	feature	Reproducibility	N/A
Status	closed	Resolution	suspended

Summary	0005918: Database: Moving from Date/Time field to UnixTime Format
Description	We Should consider moving database from date/time to UnixTimeStamp http://en.wikipedia.org/wiki/Unix_time for easier multi platform Compatibility by using unsiggned longword (0 to 4294967295 = 1. Jan 1970 00:00:00 -> 7. Feb 2106. 06:28:15) Also SQL queries should be much faster.
Tags	No tags attached.

Fixed in build

rusty 2009-09-03 20:00 administrator ~0018722	Jiri, please review and triage as necessary.

jiri 2009-09-07 16:54 administrator ~0018739 Last edited: 2009-09-08 07:28	I don't think it's useful at this moment since it isn't clear whether there actually will be any cross-platform problem with the current time format. We can decide later.