Julian日期到日历日期转换 [英] Julian Date to Calendar date Conversion
问题描述
您好,
我的日期是朱利安日期,我想将其转换为日历日期。
我可以使用MS Access查询的函数或表达式吗?
朱利安我正在使用的日期格式为: 2458003 ,相应的日历日期应为: 09/06/2017
如果我将今天的日期(9/6/17)转换为Julian日期,那么它将变成17249或2017249。 / p>
您能给我们一个逻辑,将今天的日期(9/6/17)转换为价值2458003的Julian日期吗?
谢谢。
Hello,
I have a date that is Julian date and I would like to convert it to the calendar date.
Is there a function or a Expression for MS Access query that I can use?
The Julian date format that I'm using is: 2458003 and the corresponding Calendar date should be :09/06/2017
Hi,
If I convert today's date (9/6/17) into Julian date, it would turn out to become 17249 or maybe 2017249.
Can you give us a logic for converting today's date (9/6/17) into a Julian date with a value of 2458003?
Thanks.
这篇关于Julian日期到日历日期转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!