Timestamp -- sequential?

[metazai]

And heeeere's funky little question. The UNIX timestamp produced in MySQL -- is it sequential? In other words, could I use it to sort date/time events simply by asking which number is bigger?

[redhead]

Yes it is sequential, but how can you be sure two seperate users dosnt submit within the same second?
for this an auto_increment index number is essential.

[sde]

Originally Posted by redhead

Yes it is sequential, but how can you be sure two seperate users dosnt submit within the same second?
for this an auto_increment index number is essential.

good point, but he may also be talking about a record where the date could be updated, in which an increment field wouldn't work.

[metazai]

You're both right. Regardless, I'm going another way with it.

=+)

Thanks for the quick replies!