Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2006-06-07 : 12:18:27
|
| How to convert date to Julian day and Julian to date?Thanks.DanYeung |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-06-07 : 12:27:23
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519Go with the flow & have fun! Else fight the flow  Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-07 : 13:41:12
|
| Julian date is a term that is often misused. Make sure you understand if you want the true Julian date or the ordinal date.See my explanation of this on this link, in my post from 05/02/2006 08:07:04http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762Both are available in the function that spirit1 posted the link to.CODO ERGO SUM |
|
|
|
|
|
|
Convert date to Julian day