| cannot see timestamp [message #372338] |
Sat, 03 February 2001 01:46  |
timmy
Messages: 10
Registered: February 2001
|
Junior Member |
|
|
|
i created a table with <timestamp> date default sysdate ...when i insert values into the table in the other fields i do not get any values in the timestamp field...is there something i have to do to enable this...also what would i write to have a field in the same table display the date +14days from the insertion date?.(sysdate+14)?...luv you all for the help...thanks
|
|
|
|
| Re: cannot see timestamp [message #372345 is a reply to message #372338] |
Sat, 03 February 2001 09:13  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
It should insert default sysdate when you insert record
e.g:
create table sample(sampno number,sdate date default sysdate,sdate1 date default sysdate+14);
insert into sample(sampno) values(1);
oracle inserts sysdate,sysdate+14 values in to table for that record.
Suresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
