Re: Formatting timestamp in MySQL outfile

[Jeff Shapiro]

You should be able to use DATE_FORMAT to format the TIMESTAMP anyway you need.

Check out DATE_FORMAT at:
http://www.mysql.com/doc/en/Date_and_time_functions.html
At 20:01 +0530 3/26/03, 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
Filter guard: sql,query



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
--

Jeff Shapiro, Colorado Springs, CO, USA

At work I *have* to use a Windows machine, at home I *get* to use a Mac.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]