عندى مشكله فى الفورمات بتاعة الوقت
هل هناك فى الجدول create table t1
a time
their is no type in table named time
as iwant to write time as hh:mi:ss in the table
09:30:09
how can i write this format in atable


as if when i open alov then atime write as char
then it write as
93009
that is the problem

time1 column must be define as datetime..
then
lets say you want to insert table try this ..

insert into table_test (time1) values to_date(to_char('2000/12/23 00:00:00','yyyy/mm/dd hh24:mi:ss'));

and good luck..
وكل عام والجميع بخير ..

ياجماعه انا لا اريد اظهار التاريخ

لا يوجد datetime in tables

فعلا لايوجد datetime في انشاء الجداول ولكن يوجد datetime في الفورم بلدر

ممكن تخلى ال
data type varchar2

مرحبا
make sure that the field is of type date, because date contains both date and time.
When you insert data into the field insert it as complete date datetype
for example

Insert into table2 values (sysdate);

now sysdate is saved in table as both date and time.
I do not care that it contains both data and time, because when i write my query, i can show the time component only

SQL> select to_char(sysdate,'hh:mi:ss') my_time from dual;

MY_TIME
--------
11:32:33

SQL> select to_char(sysdate, 'Day - hh24') xx from dual;

XX
--------------
Wednesday - 23

So as you can see, i can control how to display the time information by extracting only the intersting part our of the entire date format

Ammar Sajdi
Oracle Consultant, CEO
REALSOFT/PALCO www.e-ammar.com
www.palco-me.com
www.realsoft-me.com
لا بد ان ياتينا عيد على شواطئ غزة
وتصهل فية ماذن القدس
ويشمخ البحر في يافا بالعيـــد وعوادة
وكل عام واتتم بخير