PDA

View Full Version : 1.5 sort by date bug?

devenh
16th of February 2004 (Mon), 16:43
Haven't installed RC 2 yet, but sorting by date only resolves down to the second. If I have two pictures, one at 10:00:00.1 and 10:00:00.3, the order may be reversed. It looks like the tenths are being ignored.

Deven
Pekka
17th of February 2004 (Tue), 04:55
This is MySQL restriction, its datetime data types do not handle fractions or a second.
devenh
17th of February 2004 (Tue), 18:44
Okay, but could we have a sort by ee_photo_exif_date and ee_photo_exif_time? I assume the current sort is using ee_photo_exif_datetime.

Deven