Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lowdown on Julian date
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00188463
Message ID:
00188568
Views:
18
>>Hello, all!
>>
>>Does anyone know what VFP's Julian date is?
>>For example, VFP gives the following for today:
>>
>>2451227
>>
>>Someone told me, however, that a Julian date is the year + days within the year, such that today would be:
>>
>>1999048
>>
>>I'm just curious...
>>
>>Mark
>
>There's Julian date and Julian daynumber. One is number of days since a given date. Other is year plus days within a year as in your example. I can't remember which term applies to which, but it seems logical to me that daynumber would be the one which is year plus day within year. If you search the web for Julian, date, day, and number, you'll get a lot of "hits" with information.
>
>FoxPro stores dates internally as the number of days since a start date (somewhere around 4000 B.C., I forget). DateTimes are stored as that day number plus a decimal part representing how much of the day has passed.
>
>Hope some of this is what you wanted to know.
>
>Cheers,
>Rich.

It appears to be somewhere around 4700 BC. What's the significance of that time period?

BTW, if you do SYS(10,1721119) it returns a character date of "03/00/0000" ?!? What kind of date is that? For that matter, what kind of date is ANY date prior to 1752, when the calendar was switched?
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform