* 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

Reply via email to