Witango-Talk: SQL data type question

2008-06-24 Thread Tom Ferguson
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

Re: Witango-Talk: SQL data type question

2008-06-24 Thread Kaustav Acharya
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

Re: Witango-Talk: SQL data type question

2008-06-24 Thread Ben Johansen
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