Re: Formatting timestamp in MySQL outfile
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 '2003123112' 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]
RE: Formatting timestamp in MySQL outfile
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 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]
Formatting timestamp in MySQL outfile
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 guard: sql,query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]