Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Timestamp - how to?

Status
Not open for further replies.
jgotthelf

jgotthelf

Programmer
Aug 1, 2000
8
0
0
US
Is there a way to get a Timestamp field in an Oracle table?
 
Sort by date Sort by votes
hi,<br>&nbsp;&nbsp;In oracle database date field itself<br>contains timestamp also.<br><br>Nagendra P.
 
Upvote 0 Downvote
Date datatype includes date and time and you can write a database trigger to automatically insert or update any column using sysdate... as in
select sysdate into :MyDateColumn from dual;

Sunil
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
79
oradba101
oradba101
latha9
  • Locked
  • Question
How to improve Execution time
Replies
3
Views
45
BJCooperIT
BJCooperIT
FreeAgentTempAcc
  • Locked
  • Question
How best to integrate Oracle Forms with a .NET app?
Replies
0
Views
22
FreeAgentTempAcc
FreeAgentTempAcc
SilverStray
  • Locked
  • Question
How to trace SYNONYM definition?
Replies
1
Views
45
SilverStray
SilverStray
kaburia
  • Locked
  • Question
How to display a long datatype variable in a message function
Replies
0
Views
39
kaburia
kaburia

Part and Inventory Search

Sponsor

Back
Top