Re: DEFAULT now() ?

On Tue, 18 Apr 2000, ty wrote:

> May someone please show me the necessary code snippets that would allow the value of a column to take the current time ( ala now() ) by default on INSERT?
>
> Indicative example:
>
> CREATE TABLE foo (
> a INTEGER NOT NULL DEFAULT 0,
> b DATETIME NOT NULL DEFAULT now()
> );
>
> INSERT INTO foo (a) VALUES (123);
>
> What happens here? Well, a row is inserted into table ``foo''
where ``a'' has the value 123 and b holds
the date & time of when the create DDL statement was executed.
I'm wondering how to get b to have the value of the time whenever any
arbitrary insert statement is executed...
>
> Ty
>
>
I think it works OK.

This is my test:
create table table1
(f1 int2 default 0 primary key,
f2 timestamp default now(),
f3 datetime default now()
);

biology=> \d table1
Table = table1
+---------------------------+----------------------------------+-------+
| Field | Type |Length |
+---------------------------+----------------------------------+-------+
| f1 | int2 not null default 0 |2 |
| f2 | timestamp default now ( ) |4 |
| f3 | datetime default now ( ) |8 |
+---------------------------+----------------------------------+-------+
Index: table1_pkey

biology=>insert into table1 (f1) values ('1');
biology=>insert into table1 (f1) values ('2');
biology=>insert into table1 (f1) values ('3');
and so on...

biology=> select * from table1;
f1|f2 |f3
--+----------------------+----------------------------
1|2000-04-18 11:30:01-04|Tue Apr 18 11:30:01 2000 EDT
2|2000-04-18 11:30:18-04|Tue Apr 18 11:30:18 2000 EDT
3|2000-04-18 11:30:24-04|Tue Apr 18 11:30:24 2000 EDT
4|2000-04-18 11:30:28-04|Tue Apr 18 11:30:28 2000 EDT
7|2000-04-18 11:41:52-04|Tue Apr 18 11:41:52 2000 EDT
8|2000-04-18 11:41:59-04|Tue Apr 18 11:41:59 2000 EDT
9|2000-04-18 11:42:05-04|Tue Apr 18 11:42:05 2000 EDT
(7 rows)

--------------------------------------------------------
Margarita Barvinok University of Michigan
System Administrator II Department of Biology
brita(at)umich(dot)edu
---------------------------------------------------------