Skip to content
Advertisement

Is there an alternative to timestamp in oracle to show the time?

I am wondering whether or not there is an alternative to timestamp to display the time as well as date? I don’t really want to use timestamp as it confuses me and I am not sure if I have done it right anyway.

My code can be seen below:

here is the outcome of the first bug insert statement

here is the outcome of the first bug insert statement, also trying to get rid of all the 0s.

Any help would be greatly appreciated!

Advertisement

Answer

The DATE data type stores time and date. Read Oracle Docs – DATE Data Type for more information.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement