Get data using sql statement

[nirrobi]

HI,

What is the right syntax to load table with"

where table.date > 2013?

Year is after 2013 - I got many kind of error.

Many thanks.

[Seth_C_Bauer]

@nirrobi what is the datatype of the date column?

Something like this may work, but without the schema of the table no one can directly help you

select <column1>, <column2>, etc
from table
where date > '2013-1-1'

[nirrobi]

Hi,

the data type is:

2015-10-04 00:00:00

I succeed in excel query to filter by date but its look like:

DATE>{ts '2015-10-04 00:00:00'}

when I paste it in power bi I get the error:

Oracle: ORA-00911

Any idea?

many thanks.

Nir

[Seth_C_Bauer · Accepted solution]

@nirrobi you can look here to determine the cause

http://www.techonthenet.com/oracle/errors/ora00911.php