[osflash] [flash/php/remoting] MySQL's datetime or unix timestamps?

[Marcelo de Moraes Serpa]

Hello list,

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://osflash.org/pipermail/osflash_osflash.org/attachments/20061026/6b4695d7/attachment.htm