Photo by Hans Bernhard, Wikimedia Commons Nut, Egyptian goddess of the sky, with the star chart in the tomb of Ramses VI. He was the first to suggest that the movement of the planets, sun, moon, and stars could be equated in numbers. He postulated that the earth is spherical in shape as other celestial bodies are. He came up with this idea when he saw ships disappear past the horizon as they sail. Pythagoras is another Greek philosopher who is better known for mathematics but also has contributions in Astronomy. He is also responsible for calculating the tilt of the earth’s axis and the conceptualization of leap day. It is closely accurate considering the lack of apt technology during that time. His computation was off by only a few hundred or a few thousand miles. His most important contribution is the calculation of the earth’s circumference. He is well-known for several astronomical breakthroughs. He has excelled not in the field of astronomy alone but in the field of geography, mathematics, poetry, and music as well. One of the most notable Greek scholars is Eratosthenes. They are popularly known as the fathers of ancient astronomy formulating theories and mathematical equations in an attempt to explain the universe. If we talk about Astronomy, the Greeks definitely first come to mind. Babylonian AstronomyĪristarchus’s 3rd-century BCE calculations on the relative sizes of (from left) the Sun, Earth and Moon, from a 10th-century CE Greek copy. With all these inventions and discoveries, it seems like the world connived to shape the astronomy of today. From initially looking up and gazing at the stars, man has invented tools like the telescope to magnify and clearly see the yet unseen. The fascination was so strong it was enough for humans to not only be contented with what can be seen by the naked eye. Our fascination with the celestial bodies has evolved through the centuries. Our interest in Astronomy can be dated back to ancient times. From the stars, sun, moon, and planets for us to admire, our world has never been short of attraction! And there is nothing more beautiful than the heavenly bodies set above us to see. We as human beings are greatly attracted to beauty. With all their inventions and discoveries, it seems like the world connived to shape the astronomy of today.
SELECT dbo.FromRomanNumerals ( dbo.Astronomical chart from Senemut’s tomb, 18th dynasty (1463 BCE) / Photo by NebMaatRa, Wikimedia Commons WHILE ( 'failed iteration test at %d test', 16, 1, ) RAISERROR ( 'failed fourth test' ,16 ,1 ) RAISERROR ( 'failed second test' ,16 ,1 ) code: Select dbo.FromRomanNumerals('CXVII') This is a simple routine for converting roman numeral into an integer The Mediaeval-style 'roman' numeral as a string. Why: Added explicit collation and added test to 200,000
This is a simple routine for converting a decimal integer into a roman numeral. It will doĮgyptian and Babylonian numerals too but I felt that this was getting to be minority interest.ĬREATE FUNCTION dbo.ToRomanNumerals ( INT ) I thought the mediaeval style that you see on clock-faces was more of a challenge and anyway, it is standard in typography.
If you want the traditional style of Roman Numeral where 4 is written IIII instead of IV and forty is written XXXX instead of XL and so on, then just add the entries and it should all work fine. I know you can do these routines as CLRs but so what? Natuarally, you'd choose to have the roman to integer conversion table as a view rather than construct it in a function.
This is used sometimes for interview questions so stick these in your back pocket. SQL was capable of a more compact routine. They are handy for all sorts of little jobs, I've had them in some form or another for some time but dusted them out when someone was trying to tell me how compact some damn new OO language was and used a conversion routine as an example. Here are a couple of functions to convert between roman numerals and integers.