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 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
>
> Alternatively can I set the delimiters to '' or NULL somehow?
>
> Things I DON'T want to do include:
> str_replace() or =~ s/[- :]//g
> SELECT SOMEFUNC(mydate) AS mydate
> use TIMESTAMPS (all those luverly bonds that expire after 2037!)
>
> TIA with fingers crossed, bated breath and unbounded optimism...
>
> Jeff
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
