3:12 PM
To: [EMAIL PROTECTED]
Subject: Re: [SQL] staggered query?
Hi Try this..
SELECT Col1 , Col2
FROM yourtable
WHERE to_number(to_char(col1, 'SS'),'99') / 10 ) in
(10,20,30,40,50,00);
HTH
Denis
- Original Message -
From: Vincent Ladlad [EMAIL PROTECTED]
To: [EMAIL
] staggered query?
hi! im new to SQL, and i need to find a solution
to this problem:
i have a table with two columns, the first column
is of type timestamp.
the table contains hundreds of thousands of records.
i need to get all the entries/records at every 10 seconds
interval
hi! im new to SQL, and i need to find a solution
to this problem:
i have a table with two columns, the first column
is of type timestamp.
the table contains hundreds of thousands of records.
i need to get all the entries/records at every 10 seconds
interval. example, given a table:
hh/mm/ss |
