I have a table that You need to store only the schedules of my application. I'm going to insert only team ... I'vê tried coverer but not right ..
Ex:
insert into raca values (4,1,'Rot','Grande',to_date('01:00:00', 'hh24:mi:ss'))..
insert into raca values (4,1,'Rot','Grande',to_date('01:00:00', 'hh24:mi:ss'))..
insert into raca values (5,1,'podle','pequeno',to_date('01/01/2007 00:30:00','dd/mm/yyyy hh24:mi:ss'),to_date('01/01/2007 01:30:00', 'dd/mm/yyyy hh24:mi:ss'))
select * from raca;
select to_char( campo , 'hh24:mi:ss') hora
from raca;
INSERT INTO BAIRRO ( CDBAIRRO, NMBAIRRO, TEMPENTREGA)
VALUES ( 01, 'Aclimação', to_date('20:00', 'mi:ss'));
select * from bairro
CDBAIRRO NMBAIRRO TEMPENTREGA
---------------------- -------------------- -------------------------
1 Aclimação 01/10/07
1 rows selected
select to_char(TEMPENTREGA, 'hh24:mi') hora from ...
Users browsing this forum: No registered users and 10 guests