CODEWITHSUNDEEP
cdate
Derek Ekins
Derek Ekins

Reputation: 11391

What date format is this?

I am trying to query some data out of Home Bank using the data file it produces.

This is a transaction that appears in the file:

<ope date="734309" amount="-14.24" account="4" dst_account="0" paymode="0" flags="1" payee="239" category="2" wording="" info="" tags="" kxfer="0" />

I am interested in the date="734309". I've not seen this format before so don't know how to parse it.

The application is written in C if that is any help.

Upvotes: 1

Views: 145

Answers (2)

Keith Thompson
Keith Thompson

Reputation: 263217

It's probably the result of the SQL TO_DAYS() function, which represents the number of days since the first day of 1 A.D. (I don't know whether TO_DAYS() is specific to MySQL or if it's a standard SQL function.)

Upvotes: 0

Thomas
Thomas

Reputation: 181735

734309 / 365 = 2011.80548

So I guess it's something like "days since 1 January in the year 1". If you know the actual date that that number should represent, you can reconstruct the precise offset from there.

Upvotes: 4

Related Questions