Home » SQL & PL/SQL » SQL & PL/SQL » about entring the time
about entring the time [message #20737] Sun, 16 June 2002 20:59 Go to next message
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 Go to previous message
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
Previous Topic: Re: Simple SQL Query.
Next Topic: Group by time duration
Goto Forum:
  


Current Time: Fri Mar 29 05:25:13 CDT 2024