MySQL NOW() Tutorial

Kada nam je potrebno sistemsko vreme i datum koristicemo SQL funkciju NOW().

SQL NOW() komanda je prosta:

SELECT NOW() FROM naziv_tabele;

Recimo da nam je potrebno trenutno vreme i datum za neki izvestaj u kome su ukljucene Cene iz tabele "Prodavnice":

SELECT proizvod, raspolozivo, cena, NOW() AS trenutnovremedatum FROM prodavnice;

mysql> SELECT proizvod, raspolozivo, cena, NOW() AS trenutnovremedatum FROM prodavnice;
+-----------+-------------+---------+---------------------+
| proizvod  | raspolozivo | cena    | trenutnovremedatum  |
+-----------+-------------+---------+---------------------+
| Kafa      |         121 |  150.85 | 2011-10-25 01:32:46 |
| Cigare    |          50 | 300.951 | 2011-10-25 01:32:46 |
| Hleb      |          43 |  45.254 | 2011-10-25 01:32:46 |
| Hleb      |          23 |  55.237 | 2011-10-25 01:32:46 |
| Pavlaka   |         155 |   50.21 | 2011-10-25 01:32:46 |
| Mleko     |          68 |  90.657 | 2011-10-25 01:32:46 |
| Mleko     |          91 |  87.387 | 2011-10-25 01:32:46 |
| Pavlaka   |         155 |  50.459 | 2011-10-25 01:32:46 |
| Ajzaklija |          38 |     650 | 2011-10-25 01:32:46 |
| Jabuke    |          35 | 120.471 | 2011-10-25 01:32:46 |
| Ajvar     |          28 | 270.298 | 2011-10-25 01:32:46 |
| Somun     |          10 |  59.771 | 2011-10-25 01:32:46 |
| Bakalar   |          29 | 400.231 | 2011-10-25 01:32:46 |
+-----------+-------------+---------+---------------------+
13 rows in set (0.00 sec)

mysql>