Formatting timestamp in MySQL outfile

2003-03-26 Thread anirudha kukreti
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 '2003123112' any help would be greatly appreciated. Thanks in advance anirudh Filter

RE: Formatting timestamp in MySQL outfile

2003-03-26 Thread Don Read
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 '2003123112' any help would be

Re: Formatting timestamp in MySQL outfile

2003-03-26 Thread 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