Displaying timestamp columns are a PIK (pain in keester) if you ask me.<g>
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. The only way around this is to use the Date_Format on every TimeStamp column in every SQL statement. which produces a lot of unnecessary work for the developer. 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? Brent --------------------------------------------------------------------- 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
