timestamp problem [message #224200] |
Tue, 13 March 2007 06:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
karthi_smarty04
Messages: 19 Registered: January 2007 Location: COIMBATORE
|
Junior Member |
|
|
hello experts,
iam currently using oracle 9i forms.
i have created a table with following description
create table student
(
name varchar2(20),
time_in timestamp
);
i tried to create a datablock using datablock wizard.i am getting 'assertion error' when i try to select the student table using query bulider.
please help me out in solving this problem
[Updated on: Tue, 13 March 2007 06:59] Report message to a moderator
|
|
|
Re: timestamp problem [message #225448 is a reply to message #224200] |
Mon, 19 March 2007 23:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Please review the Oracle documentation concerning data types. Use 'date' in the database definition.
David
|
|
|