In message <[EMAIL PROTECTED]>, Thomas Spahni <[EMAIL PROTECTED]> writes >On Mon, 26 Nov 2001, Brent wrote: > >> A Select statement will display the TmeStamp as 20011115095105. Now I ask >> you, how many users will understand this format? >> Why not display TimeStamp in the same format as DateTime? At least then the >> TimeStamp is in a meaningful representation that users can understand. > >> I'm not saying to change the input format. Inputting the TimeStamp data can >> be kept the same, but it should have a default display format similar to >> DateTime. The actual format for TimeStamp and DateTime could be stored in >> the my.cnf or my.ini file so the display format can be adjusted on the >> server. This format string could be the parameter used in the Date_Format >> function. >> >> What do you think? > >Changing the default output format is a very bad idea because it will >break every client application depending on the current format. The >default format has to be controlled by the client software at table >creation time and not on a per user basis in the config files. > >The remaining option I can see is to ADD a new display format and >define TIMESTAMP(1) or possibly TIMESTAMP(15) to display a string like >a DATETIME column. >
Well till then... but I have some perl bits that you can have it you want? M. -- Work:- postmasterAThinwick.demon.co.uk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
