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 |
|
trusted4u
Posting Yak Master
109 Posts |
 Posted - 2003-10-17 : 09:45:59
|
| Hi :Is there any function in sql server that converts date into Julain date format ?A Julain date is a number of 6 digits, the first 3 digits are for the year and next 3 for day number in this year.Eg : 102001 = {01/01/2003}The first part is 102 that stands for year. To get this value, the actual year with subtracted from 1900. The second part is day number in this year, it must be always 3 digits. If it is less then it is preceeded with zeros. For eg : Jan 31 = 031Feb 27 = 058 and Jan 02 = 002.Any help will be really appreciated.Thanks- Marjo. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-10-17 : 11:08:31
|
| Lookup CONVERT in SQL Books Online |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-17 : 11:12:45
|
| SELECT CONVERT(varchar(4),DATEPART(yy,GetDate()))+CONVERT(varchar(3),DATEPART(dy,GetDate()))Brett8-) |
|
|
|
|
|
|
Convert Date To Julain Date Format