date and timestamp storage problems

[mallz]

hi,

i have to accept the date and time as inputs from my jsp form and store it in my table.
but,
the problem is that whn i use date datatype it displays time as well.
i want the date data type to accept and display only date
and the timestamp datatype to accept and display only time.
how do i do that?

im using oracle 9i

[Dave44]

hi,

i have to accept the date and time as inputs from my jsp form and store it in my table.
but,
the problem is that whn i use date datatype it displays time as well.
i want the date data type to accept and display only date
and the timestamp datatype to accept and display only time.
how do i do that?

im using oracle 9i

what oracle is storing and what you display are two different things. you can store the information in the same field in the table and just select 2 columns with the information that you want. like this:

[144]dave@ORADB> create table temp (
  2  my_date    date
  3  );
 
Table created.
 
Elapsed: 00:00:00.01
[144]dave@ORADB> insert into temp values (sysdate);
 
1 row created.
 
Elapsed: 00:00:00.01
[144]dave@ORADB> select to_char(my_date,'mm/dd/yyyy') the_date,
  2         to_char(my_date,'hh:mi:ss am') the_time
  3  from temp;
 
THE_DATE   THE_TIME
---------- -----------
03/12/2007 07:23:59 pm
 
 

[shivchandan]

Hi,
Please tell me
how can i save any TIME rather than server time in table?

[debasisdas]

In oracle date field takes 7 bytes .

In these 7 bytes oracle stores century,year,month,date,hour,min,sec.

So u can easily store both date and time information to date datatype field.

Again u can also easily retrive what u want to retrive. No need to create separete fields.

As far as time stamp is concerned it stores all the field of date plus fraction of secords upto maximum 9 places (naano second) and default 6 places (micro secord.) This is used for those cases where u need to store time very accurately like some engineering or scientific data.