* Jarkko Toivonen > I was just wondering that how to add date/time to every report > run in MySql. > I've got a database that contains everything about my home-made > beers. I run > a select-query sometimes and I want to include the time when it > was run in it.
Add "now() as report_time" to your field list: SELECT *,now() as report_time FROM table WHERE field='A'; The timestamp will be available as a field named 'report_time'. Put this in the header (or footer) of your report. -- Roger query --------------------------------------------------------------------- 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