This is a discussion on Application that generates 162 million records per day within the MySQL Database forums, part of the Database Forums category; Erol Fornoles wrote: > Aside from the allowable date ranges, would there be a trade-off if I > used ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Erol Fornoles wrote:
> Aside from the allowable date ranges, would there be a trade-off if I > used Unix-style timestamps? Is there a conversion function available > that converts the Unix-style timestamp to a normal timestamp or > datetime? FROM_UNIXTIME() converts from a UNIX timestamp to a MySQL date format. UNIX_TIMESTAMP() converts from MySQL date format to a UNIX timestamp. See http://dev.mysql.com/doc/refman/4.1/...functions.html Regards, Bill K. |