Insert date on a table [message #347774] |
Sat, 13 September 2008 18:55  |
juanp.contreras
Messages: 8 Registered: September 2008
|
Junior Member |
|
|
Hi...
I'm trying to insert a date in a table with an attribute DATE or TIMESTAMP (I've tried with both datatypes). But, every attempt fails given that the DBMS "cuts" the information and then, it only inserts the date and not the hour, minutes or seconds. Also, Oracle SQLDeveloper only shows the date...
how do I should insert a complete date?
how do I get Oracle SQLDeveloper to show only the time (not the other date data)?
Thanks...
|
|
|
|
Re: Insert date on a table [message #347800 is a reply to message #347774] |
Sun, 14 September 2008 01:36   |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Quote: | But, every attempt fails given that the DBMS "cuts" the information and then, it only inserts the date and not the hour, minutes or seconds.
|
This is 100% wrong. Oracle always inserts and stores both date and time, it is just that it doesn't always display exactly what you want to see. Read the links that anacedent posted, but don't get confused that he meant for you to use the function whilst inserting, only use it whilst displaying the data.
|
|
|
|
|
|
|