Re: [SQL] 'now - 4 hours ago' ?

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(at)agria(dot)hu |
| System Administrator | URL: http://www.agria.hu/ |
`----------------------------------------------------------'