Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Julian date + time
Message
De
01/09/2005 08:46:13
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
01/09/2005 08:42:01
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
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:
01045787
Vues:
17
>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
>
Sorry, that will give you the number of seconds from midnight. To convert to a datetime, you might do additional manipulations to convert to hours, minutes and seconds, and then (for example) use the datetime() function.

I think it would be something like this:
Remainder = jd - int(jd)
Hours = int(Remainder * 24)
Remainder = Remainder - Hours * 24
Minutes = int(Remainder * 24 * 60)
Remainder = Remainder - Minutes * 24 * 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
Répondre
Fil
Voir

Click here to load this message in the networking platform