Moons of Jupiter

1–10 of 61
IDNameDiameter
(km)
Density
(km/m3)
Rotation
(days)
Discovery date
5 Io 3659 3529.4 SYN Jan 7, 1610
6 Europa 3125 2984 SYN Jan 7, 1610
7 Ganymede 5270 1940 SYN Jan 7, 1610
8 Callisto 4817 1851 SYN Jan 7, 1610
3 Amalthea 250 900 SYN Sep 8, 1892
11 Himalia 170 0.396 Nov 3, 1904
13 Elara 80 0.5 Jan 2, 1905
48 Pasiphae 36 Jan 27, 1908
52 Sinope 28 Jul 21, 1914
12 Lysithea 24 Jul 6, 1938
1–10 of 61

This table has many more records, and so it is split into pages. One of the columns here contains dates (cf_sorTable has no problem sorting dates or times either).

Note that dates (as well as times, numbers, and currencies) are formatted appropriately for your locale. On this page, the locale is set to "English (US)". For more information about locales, see the documentation for the ColdFusion function setLocale().

Note that this example fails in BlueDragon, which prohibits blank values in a numeric column when re-sorting by query-of-queries.

View the simple source code for this example.