about entring the time [message #20737] |
Sun, 16 June 2002 20:59 |
adeel
Messages: 4 Registered: June 2002
|
Junior Member |
|
|
i want to enter the time in time format how it is possible
i have the datatype of that field is date;
and i m entering the date from forms,
there i also have the datatype of date,
if i change it to the time than an error has occur
|
|
|
Re: about entring the time [message #20738 is a reply to message #20737] |
Sun, 16 June 2002 22:11 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Change the format mask of this date field. Anyhow, Oracle stores date AND time, but shows only the date part by default (depends on your settings though).
The date format you're looking for is something like 'HH24:MI:SS'.
MHE
|
|
|