If I want to store dates in a SQL table as seconds (DATESTOSECS) what data
type would be the best?
TIA
Tom Ferguson
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
If i'm understanding you correctly,
perhaps you can store the data as a plain number field like below:
create table mytable
(id not null primary key,
timetosecs number);
Was that what you were looking for?
Kaustav Acharya
Technical
just use full INTEGER data type
Ben
On Jun 24, 2008, at 12:19 PM, Tom Ferguson wrote:
If I want to store dates in a SQL table as seconds (DATESTOSECS)
what data
type would be the best?
TIA
Tom Ferguson
TO