Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Date & Time

From: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
To: Dale Anderson <danderso(at)crystalsugar(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Date & Time
Date: 1999-11-30 22:48:13
Message-ID: 19991130164813.A9625@wallace.ece.rice.edu (view raw or flat)
Thread:
Lists: pgsql-general
Dale - 
How about this?

Ross

test=> create table test (t_id int, start datetime, what text);
CREATE
test=> insert into test values (123, now(), 'Name');
INSERT 684299 1
test=> select * from test;
t_id|start                       |what
----+----------------------------+----
 123|Tue Nov 30 16:46:07 1999 CST|Name
(1 row)

test=> insert into test values (456, now(), 'Other');
INSERT 684300 1
test=> select * from test;
t_id|start                       |what
----+----------------------------+----
 123|Tue Nov 30 16:46:07 1999 CST|Name
 456|Tue Nov 30 16:46:15 1999 CST|Other
(2 rows)

test=> 

-- 
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005



On Tue, Nov 30, 1999 at 04:34:34PM -0600, Dale Anderson wrote:
>     How would I insert the current date & time into a record during an insert, IE such as the Oracle SYSDATE function??
> 
> ( insert into test values (123, SYSDATE, 'Name');
> 
> Thanks,
> Dale.
> 
> 
> 
> ************
> 

In response to

  • Date & Time at 1999-11-30 22:34:34 from Dale Anderson

Responses

pgsql-general by date

Next:From: Bruce MomjianDate: 1999-11-30 23:58:25
Subject: Re: [GENERAL] Date & Time
Previous:From: Dale AndersonDate: 1999-11-30 22:34:34
Subject: Date & Time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group