Storing Date and Time through Forms 6i

Hai,

I want to store date and time in a table through oracle forms 6i. I am able to store the date but not the time.

I tried to set the date and time in the oracle form but while commiting the form only the date part is stored in the table and not the time part.

Please help me in this regard.

Thanks and Regards,

A.Mohammed Rafi Aamiri.
E-Mail : rafi_amr@yahoo.com

Assuming:
The datatype of the field in the table is DATE, we'll call it
the table MYTABLE and the field MYDATE.

The dataype you are using in Forms is either VARCHAR2 or DATE.

What do you get when you do this?:


What does your insert statement look like?

In the table the datatype of the column is DATE.

I want to store both date and time in the column through Oracle Forms 6i.

I am able to store the date but the time part is not able to sotre. Also I am using Commit_Form procedure to store the values in the table.

I'm not communicating with you very well.
Get into SQLPLUS. I do not know the name of your table or the column that stores the date


what do you see? In other words, paste the result of this so I can see it, too.

hello,
try

select to_date('24.12.2004 13:42','DD.MM.YYYY hh24:mi') from dual;

you can play whith that.
"to_date" converts the string to date.
So you cann make

insert into yourtable column1, .... values (to_date('24.12.2004 13:42','DD.MM.YYYY hh24:mi'), .....;