On my current project, I will constantly be using temporal data. The client is being developed on Flash 8 (mtasc to compile, of course :)), and the back-end is PHP4.3, the database is MySQL 5. On my last project I used to use UNIX timestamps to handle date and time data. Flash Date datatype also only works with timestamps (with the weird *1000 offset), but I've saw on many places that it is best to use MySQL's DATETIME datatype for many reasons (dates before 1970, dates after 2030, SQL funcions to handle them...) but I feel that I will have a hard time having to convert from DATETIME to unix timestampes and vice-versa as I don't see much support for them on PHP and Flash API.
So I'm asking for some advice from more experienced flash/php as I'm a little lost in this subject.
Thanks in advance,
Marcelo.
_______________________________________________ osflash mailing list [email protected] http://osflash.org/mailman/listinfo/osflash_osflash.org
