In article <37703B93.9FAE1DC4_at_home.com>,
MLQ <mlq_at_home.com> wrote:
> I need to display date and time in a column in my D/B. Is
> there such a type in Oracle and can I Display them together
> in the same column. Ie. dd/mm/yy hh:mm:ss (Or something
> similar).
>
> Thanks
>
you may try this.. define the column to be of type DATE.
If u want to use the current time of the system, then just assign
sysdate to that colunm. During display, u can say
to_char(col_name,'dd/mm/yy hh24:mi:ss').
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Jun 23 1999 - 00:02:29 CDT
