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 |
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-12-30 : 11:24:22
|
Dear All,If anybody worked on T-SQL script determines the Julian week,please let me help.I am hearing this first time.Please post any code which you have worked on Julian weekThanks,Gangadhar |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-12-30 : 11:34:02
|
There is no julian week as far as I know.Do you mean julian date?And what is your problem / input / wanted result.Do you have an example? No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-12-30 : 13:53:22
|
1 + (DATEPART(DAYOFYEAR, @DateValueHere) - 1) / 7 N 56°04'39.26"E 12°55'05.63" |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-12-31 : 00:13:31
|
Dear All,Can one of help me to write a sql script that produces the last day of the week according to the Julian Calendar? For instance, take the current date and use that to determine the last day of the week.Ex: Today is 12/30/2009 and the Julian calendar determines that the last day of the week is Jan 2nd. Thanks,GAngadhar |
|
|
vikky
Yak Posting Veteran
54 Posts |
Posted - 2009-12-31 : 01:19:56
|
hi,select dateadd(d,7-datepart(dw,getdate()),getdate())Thanks,vikky. |
|
|
|
|
|
|
|