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
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
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