Re: how to declare type data

Sergio Cotti <sergiof31_at_hotmail.com> wrote:
> anydoby can tell me what can i do to declare a column of type "date"
> and use this format dd/mm/yyyy hh:mm ?

The type you want is DATE, see the documentation of Oracle about datatypes. To insert the data use

insert into <table> (...) values ( to_date(value,'DD/MM/YYYY HH:mm')...)

see about "to_date"
> How can i do to get the current date and time? i want to use this
> format: dd/mm/yyyy hh:mm.

select to_char(date_field,'DD/MM/YYYY HH:mm') from ...

see the documentation about TO_CHAR

> Thanks in advance and excuse me for my english.
> Daniele.

> --
> Posted from [213.156.38.68]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Nov 06 2001 - 05:42:02 CST