Re: [SQL] 'now - 4 hours ago' ? - Mailing list pgsql-sql

On Thu, 18 Jun 1998, Petter Reinholdtsen wrote:

|  CREATE TABLE testdate(
|       received timestamp DEFAULT CURRENT_DATE,
|       info text NOT NULL
|       );

I think CURRENT_DATE will be parsed to the table creation's time.
so better to use:

    CREATE TABLE testdate (
        received timestamp DEFAULT timestamp(now()),
        info     text      NOT NULL
        );

    Redax

.----------------------------------------------------------.
|Zsolt Varga            | tel/fax:   +36 36 422811         |
| AgriaComputer LTD     | email:     redax@agria.hu        |
| System Administrator  | URL:       http://www.agria.hu/  |
`----------------------------------------------------------'