Moons of Jupiter

1–10 of 61 Page: 123456
ID	Name	Diameter (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 Page: 123456

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.