gistfile1.txt

configurator=# SELECT NOW();
              now
-------------------------------
 2008-10-08 15:17:06.234692-06
(1 row)

configurator=# SELECT created_at FROM configurations LIMIT 1;
     created_at
---------------------
 2008-10-07 16:38:28
(1 row)

configurator=# SELECT EXTRACT(microseconds FROM created_at) FROM configurations LIMIT 1;
 date_part
-----------
  28000000
(1 row)

configurator=# UPDATE configurations SET updated_at = NOW();
UPDATE 15
configurator=# SELECT updated_at FROM configurations LIMIT 1;
         updated_at
----------------------------
 2008-10-08 15:20:51.506686
(1 row)