RE: specifying date format for retrieving dates and datetimes

2001-05-18 Thread Jeff Armstrong
> Use ints and bigints? INT much use I's afraid. I want external data processing to get back a format that it can use, but still want to be able to use the MYSQL date functions, which are excellent. A better idea would be TIMESTAMPS(14) but these suffer from the 32bit int 2037 problem (aka the Y

specifying date format for retrieving dates and datetimes

2001-05-17 Thread Jeff Armstrong
Most DBs allow specification of date format when retrieving dates from a server, usually as part of the database connection. Is there a simple way to force mySQL to always return dates and datetime in ISO long format, without the '-', ':' and spaces? (in a TIMESTAMP(14) like format) I always wan