Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Julian date + time
Message
De
01/09/2005 08:42:01
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
01/09/2005 08:39:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01045783
Message ID:
01045786
Vues:
14
>I'm using 'FeedForDev' to access RSS feeds. The object returns me the folowing number as a 'datetime'-fields :
>
>38561,5024652778
> which stands for
>Thu, 28 Jul 2005 12:03:33 +0200
>
>The number '38561' is the Julian number of the date ({1899} + 38561 - 1). That part is OK.
>
>But how do I recognize the time part ? How do I convert 5024652778 ?

Multiply by the number of seconds in a day.
? (jd - int(jd)) * 86400

* or perhaps you find the following more readable:

? (jd - int(jd)) * 24 * 60 * 60
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform