October 25, 2004 at 7:01 pm
Since the start of the IT industry in the early 1950s, I would guess there have been several man-centuries spent resolving date/time problems.
Being an SQL novice, I have found some brilliant bits of code in the various forums that have reduced my amaturish 30 lines of code to one line too many times to admit! Quit often a solution for one problem is discovered while researching a totally unrelated problem.
It would be great if all date/time functions and related issues where posted on one forum.
Regards,
Ian Scott
October 25, 2004 at 11:59 pm
Seconded
October 26, 2004 at 9:31 am
We'll look at this and see. We get lots of misfiled posts as it is, so I'm not sure it will help. Have you tried searching for your specific issue?
October 26, 2004 at 12:07 pm
I would recommend that anyone who works with DATETIME read:
A) Tibor Karaszi's article on the subject:
http://www.karaszi.com/SQLServer/info_datetime.asp
and
B) Rick Snodgrass' book on tempoaral SQL, which can be downloaded in PDF format from this web page:
http://www.cs.arizona.edu/people/rts/
--
Adam Machanic
whoisactive
October 26, 2004 at 1:12 pm
To add to Adam:
Almost each possible question on this topic has already been answered before with an at least effective answer. A simple search in the Google archives (or other resources) with smart search criteria will give tons of informations back.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply