I have a Clarion serial data that I need to convert to a Btrieve Date.
The clarion serial date is based from 28, dec 1800. That is the first
day. How can I convert it to a Pervasive Date? I'm using Pervasive 8
and I need to create a stored procedure to do this. With Oracle I can
do someting like :
oracle_date := ClarionDate# + to_date('01011900','ddmmyyyy');

For MS-SQL :

set @ClaRoot = 'Dec 28, 1800'
set @MSSQLRoot = 'Jan 01, 1900'
set @SqlDate = @ClaDate - datediff(day,@ClaRoot,@MssqlRoot)
How can thi be acomplished with Pervasive SQL?

TIA
Carlos San Miguel

<yatuchabe (AT) hotmail (DOT) com> wrote

Carlos,

Clarion has the DATE variable type which conforms to the Pervasive Date spec
and I believe any SQL Date. So if you have a Clarion date in a LONG
variable, just assign it to a DATE variable; the conversion is automatic.
If you create any new tables, use DATE instead of LONG for dates, TIME
instead of LONG for times, and PDECIMAL instead of DECIMAL.

HTH,
Brad Kunkel
Integrated Business, Inc.

SELECT TIMESTAMPADD ( SQL_TSI_DAY, datefield, CONVERT('1800-12-28
00:00:00', SQL_TIMESTAMP) )

Replace "datefield" with your serial date.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Coming Soon: Pervasive DataExchange Training!


yatuchabe (AT) hotmail (DOT) com wrote: