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 Customer Service Manager
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fax: (858) 847-3340
email: [EMAIL PROTECTED]
http://www.colleges.com
____________________________________________________
All the News. No Ink. - http://www.onlinetimes.com
Power to the People - http://www.campaign.com
____________________________________________________
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 UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf