Re: inserting time values to table
From: preeti <shwethanrao_at_gmail.com>
Date: 28 Nov 2005 12:38:53 -0800
Message-ID: <1133210333.449809.273550_at_g49g2000cwa.googlegroups.com>
Date: 28 Nov 2005 12:38:53 -0800
Message-ID: <1133210333.449809.273550_at_g49g2000cwa.googlegroups.com>
[Quoted] I have read the contents of those two links...but still not able to findout...
For the above mentioned table if I use the following statement to insert values
insert into time_slots values(1,'TR',TO_DATE('11:00 AM', 'HH:MI AM'),TO_DATE('12:20 PM', 'HH:MI PM')); when I try to see the values using select * from time_slots.. It list the values as "28-nov-05"
How should I insert the values?
Or do I have to change the table definition?
Received on Mon Nov 28 2005 - 21:38:53 CET