> Do you know of a way of getting this back out sensibly? (Ie 12 Jan 2003 MySQL has some very powerful date formatting functions. apt-get install mysql-doc (or your distro's equivalent) then read section "6.2.2 - Date and Time Types" and "6.3.4 - Date and Time Functions" Its a good manual, though IMHO postgresql's is better *grin*.