Re: I need some help creating a table

Hi,

zmacedo wrote:
>
> Hello all,
>
> I need some, I need to know what is the exact date format that Oracle 8
> accepts. I know the Date datatype also handles times, but I just can't
> figure out how to enter the date-time combo. Is it mm/dd/yy:hh:mm:ss? I was
> only able to enter a date in the following format dd-MON-yy. Is that right?
> Any help would be greatly appreciated. I am sorry I somewhat new at this.

as you can read in the documentation the Oracle DATE type is a 7 byte field containing:
century, year, month, day, hour, minute, and second

This design has some drawbacks:
- Date arithmetics is VERY strange and slower than necessary, e.g. to add 10 minutes to a date value you need to calculate <datevalue> + 10 / (24 * 60)
- Date values are always timestamps and often this is not what you want.

Conversion to/from character strings are done withe the TO_CHAR/TO_DATE functions.

Uwe

-- 
Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
DE-76646 Bruchsal   | http://www.richard-schneider.de/uwe
Linux - OS al dente!