Btrieve Date Integer

Posted by nmiranda on Stack Overflow See other posts from Stack Overflow or by nmiranda
Published on 2010-06-09T19:11:36Z Indexed on 2010/06/09 19:22 UTC
Read the original article Hit count: 208

Filed under:

date

|

pervasive

|

btrieve

Hi everyone, this is my question:

I'm migrating data from a Btrieve file (.dat) through Pervasive Control Center and there is field type which is defined as integer but is a date and for example the date '31/12/2009' (seen in the legacy system) is view it as the number 733772 when I export it.

The legacy system shows the date correctly but I can't export it in the same format or at least I can't convert it. Does anybody know how to convert this number through Excel or something?

© Stack Overflow or respective owner

Related posts about date

Javascript Date object expression (Date within date)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear experts, I was analyzing Javascript codes and came across this line: var date = (new Date()).getDate(); This kinda throw me off? I am pretty new to Javascript and a little curious. >>> More
Populate google.visualization.DataTable for a AnnotatedTimeLine using JSON

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a HttpHandler which returns some JSON in (i think) the correct format for a google.visualization.DataTable, but the AnnotatedTimeLine fails to work? This is the JSON returned by the Handler: {cols: [{id: 'DATE', label: 'Date', type: 'date'}, {id: 'KEYWORD51', label: 'vw cheltenham', type:… >>> More
Excel: Summing values within a certain date range (> start date and < Finish date)

as seen on Super User - Search for 'Super User'
How do I include a 'Between these dates' criteria inside a SUMPRODUCT? =Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost)) What's the way to manage dates (between) in a sum product? Thanks Mike >>> More
Extjs Date Time Picker ,HighLight particular Date instead of system date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How to highlight the particular date in extjs calender(Date Time Picker) control, As default it will highlight the system date when its shows, i need to set highlight date as sql server date. since it will be different. Is there any property or override method to change the highlight date.… >>> More
Finding date between start date and end date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I want to check whether a date is between start date and end date. i have added a where class where datepaid between '2010-04-01' AND '2010-04-15' but the problem is that it excludes '2010-04-15'. It should include end date also how can i do this? Please help me on this Regards, pankaj >>> More

Related posts about pervasive

Migrating data from Oracle database to Pervasive .DAT files

as seen on Server Fault - Search for 'Server Fault'
The requirement is to migrate some tables with data from a Oracle database server to Pervasive database's .DAT file. Then those .DAT files will be used by a Pervasive database server. The restriction is that Oracle DB can not directly migrate to the Pervasive DB. It has to generate the .DAT files… >>> More
Pervasive SQL german Umlauts Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm using the Pervasive SQL - ADO.NET 3.5 DataProvider for retrieving data out of the PSQL DB and I've noticed that the german umlauts (äöüÄÖÜ etc.) are not represented correctly in the PSQLDataReader, but in the Pervasive Control Center (similar to the sql management studio) the umlauts… >>> More
Pervasive database backup

as seen on Server Fault - Search for 'Server Fault'
I'm looking for the best way to backup my pervasive database. I've read the documentation but still have a few questions. It appears that Continuous Operations method only allows me to backup the entire database? So I'd do butil -startbu @filelist, then backup the entire database (copy, rsync,… >>> More
Standards Corner: Preventing Pervasive Monitoring

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Phil Hunt is an active member of multiple industry standards groups and committees and has spearheaded discussions, creation and ratifications of industry standards including the Kantara Identity Governance Framework, among others. Being an active voice in the industry standards development… >>> More
Pervasive & Linux

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm interested in quering a Pervasive DB server running on a Windows platform from Linux. Would anyone happen to know if this is possible, what's required and what resources there are for me to read up on it? Thanks! >>> More