On 26-Mar-2003 anirudha kukreti wrote:
> hi everybody,
>
> i would like to know, if there exists a method for getting a format like
>
> '2003-12-31 12:00:00' for the time stamp
>
> in the text file generated using the outfile command.
>
> the normal format is '20031231120000'
>
> any help would be greatly appreciated.
>
> Thanks in advance
> anirudh
DATE_FORMAT(ts, '%Y-%m-%d %T')
Regards,
--
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.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
