Re: CDBI and Oracle dates

[prev] [thread] [next] [Date index for 2004/11/24]

> Yes, an Oracle date field stores time, down to the second.  If you need 
> more granularity, there is a new datatype called timestamp
> 
> You use the to_char, to_date functions in Oracle to get at the desired 
> portions of a date field.
> 
> for example:
> 
> select to_char(sysdate, 'MM/DD/YYYY HH24,MI,SS') from dual;
> 

Sorry, I sent this before I was done.

I meant to point you at:

http://www.class-dbi.com/cgi-bin/wiki/index.cgi?WorkingWithOracleDateFields

and

you can review the oracle manuals at: technet.oracle.com, you need to 
create a userid (but it's free)

Jay