> 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
On 17-May-01 Jeff Armstrong wrote:
> 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 spac
> 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 want 20010517 rather than 2001-05-17,
> and 20010517130500 rather than 2001-05-17 13:05:00
Use ints and bigints?
