June 26, 2008 at 9:57 am
Is it possible to create a UDF Or UDT to include importing a date/time format that includeds up to 6 milliseconds rather than 3 in sql server 2000?
¤ §unshine ¤
June 26, 2008 at 10:18 am
What do you mean? SS2K only has precision to 0, 3, or 7 ms as the final digit. You could build a UDF to round those to what you need, but you can't get more precise than that.
June 26, 2008 at 11:07 am
How do I do that? with the udf? there is no way I can create it via a user defined datatype?
¤ §unshine ¤
June 26, 2008 at 11:38 am
UDT support in 2000 was very limited. Nothing I can recall about it allowed to do anything with changing the precision in any way, since that was tied directly into the float that was storing it.
I suppose you could come up with something entirely custom. As in - figure out what built-in type might be used to encode the values you want, and a function (or several) dedicated to getting stuff in or out of whatever encoding you arrive at.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply