A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Insert a date of type timestamp into oracle.
Joined: Nov 04, 2007
Dec 12, 2007 20:59:00
I have to retrieve the records in a chronological order.So I need to insert the records using time stamp so that i can compare them and retrieve.
I need the syntax of the insert statement.Please help me out in this....
Joined: Oct 06, 2007
Dec 12, 2007 22:16:00
insert into your_table(your_column) values (SYSTIMESTAMP);
Alternately you can use the to_date function to format a Date
of your own for inserting in the data base.. substitute it in place of systimestamp
insert into your_table(your_column) values (to_date(yourString, 'mm/dd/yyyy hh24:mi:ss'))
[ December 12, 2007: Message edited by: Paul Campbell ]
I agree. Here's the link:
subject: Insert a date of type timestamp into oracle.
How to get a complete string from actionmessage in action class
Insert new records in database without deleting existing records
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014