Re: how to show time
Hi!
[You might consider looking for an Oracle foum - this forum is targeted towards people that are migrating from Oracle to MySQL - not the other way around.]
You can't, at least, not as far as I know. Oracle does not have a TIME datatype like MySQL has. However, if you want perform calculations with times, you can store time as a NUMBER column. Normally, oracle performs data/time calculation on a day basis:
sysdate + 1
evaluates to exactly one day later than now. So,
sysdate + (1/24)
evaluates to exactly one hour later than now.
So you should be able to solve all your time problems using ordinary NUMBER columns
good luck!
Subject
Views
Written By
Posted
7606
March 03, 2006 12:08PM
Re: how to show time
2940
March 07, 2006 02:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.