Home » RDBMS Server » Server Administration » How do I store a timestamp to a date datatype in a table?
How do I store a timestamp to a date datatype in a table? [message #373109] Tue, 27 March 2001 21:24 Go to next message
Stanton
Messages: 1
Registered: March 2001
Junior Member
I am trying to create a table with a date column as part of a concatenated primary key. I need the time down to the second to keep the primary key unique while allowing the other part of the primary key to be used twice in one day. I want to use default sysdate and store the time in the column as well as the date.

Report message to a moderator

Re: How do I store a timestamp to a date datatype in a table? [message #373125 is a reply to message #373109] Wed, 28 March 2001 13:44 Go to previous message
Salman Khan
Messages: 51
Registered: September 2000
Member
Pryiya, Tusi tuu kamal kar dita dhotii phar kar romal kar ditta

Report message to a moderator

Previous Topic: Re: Trademark symbol
Next Topic: hide a column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 05:58:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.