1

Topic: Sampling of values of a field sys time stamp

Hello, in any way I will not invent as to select the data from the table for the certain period across the field systimestamp, all data from the table for June, 2017 is necessary
Here request
select * from result where systimestamp like ' % OF.06.17 %'
As a result the request produces nothing, prompt how as a result to make sampling?

2

Re: Sampling of values of a field sys time stamp

martinezo;
And from what pores systimestamp became in the line?

3

Re: Sampling of values of a field sys time stamp

123;
Tried to make here so - to transform at line
select to_char (SYSTIMESTAMP, ' dd-mm-yyyy ') as dt from result
As a result quits - today in the field

4

Re: Sampling of values of a field sys time stamp

Prompt how all the same to make sampling?

5

Re: Sampling of values of a field sys time stamp

martinezo wrote:

all data from the table for June, 2017

 is necessary
select * from t where ts> = date ' 2017-06-01 ' and ts <date ' 2017-07-01'

6

Re: Sampling of values of a field sys time stamp

[quote = - Eugene-] it is passed...

select * from t where ts> = date ' 2017-06-01 ' and ts <date ' 2017-07-01'

You meant it?
Wrote down your request:
select * from result where systimestamp> = systimestamp ' 2017-06-01 ' and systimestamp <systimestamp ' 2017-07-01'
There is an error
ORA-00933: incorrect end of the SQL-offer
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
Error at Line: 11 Column: 488