<div>
I'm guessing the problem with Pervasive is the EXTRACT part. &nbsp;If that's not the case, post the version of Pervasive and the error you are seeing. &nbsp;<br />
If it is the EXTRACT, the Pervasive syntax for EXTRACT (in v10 and v11, at least) is: <br />

<pre><code id="code-20-40467071-1">EXTRACT (extract_field, extract_source)</code></pre>
So your query would be :<br />

<pre><code id="code-20-40467071-2">SELECT d.whse, d.part_no, EXTRACT(YEAR, d.invoice_date), EXTRACT(MONTH, d.invoice_date)
FROM sales_history_items AS d</code></pre>
</div>


I'm guessing the problem with Pervasive is the EXTRACT part.  If that's not the case, post the version of Pervasive and the error you are seeing.  
If it is the EXTRACT, the Pervasive syntax for EXTRACT (in v10 and v11, at least) is:


EXTRACT (extract_field, extract_source)

So your query would be :


SELECT d.whse, d.part_no, EXTRACT(YEAR, d.invoice_date), EXTRACT(MONTH, d.invoice_date)
FROM sales_history_items AS d

<div>
<div class="content wysiwyg-content">
I have a query that I want to use for extracting data form a Pervasive database and then insert to a table.<br />
<br />
This is the first part of the query which works in PostgreSQL<br />
<br />

<pre><code id="code-10-28570021-1">SELECT d.whse, d.part_no, EXTRACT(YEAR FROM d.invoice_date), EXTRACT(MONTH FROM d.invoice_date)
FROM sales_history_items AS d</code></pre>
<br />
In Pervasive the invoice_date is a string like so 20141128<br />
<br />
Can someone help me with this? Once I got this working I will post the whole query is I need more help.
</div>
</div>


I have a query that I want to use for extracting data form a Pervasive database and then insert to a table.

This is the first part of the query which works in PostgreSQL

(CODE)

In Pervasive the invoice_date is a string like so 20141128

Can someone help me with this? Once I got this working I will post the whole query is I need more help.

Need help with query for Pervasive

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.