I do a lot of work in my db apps with race timing. I use ADO with SQL Server or MSAccess. I have a hard time working with performance times (where 5:15 means a performance time of 5 minutes and 15 seconds, for instance). AS nearly as I can tell, the datetime data types refer to 'time-of-day' things which processes a little differently. As a result, when I submit this type of data I just drop it in as a string but this causes problems when doing comparison-types of things.
Can someone steer me towards a better way to work with this kind of data?
Thanks!!!varchar()|||store as seconds, so smallint
rudy|||...written code to convert to seconds when I need to process it and then convert back. I just thought there had to be an easier way.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment