Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    114

    Unanswered: Data Type Question

    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!!!

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    varchar()

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    store as seconds, so smallint


    rudy

  4. #4
    Join Date
    Apr 2003
    Posts
    114

    That's what I have done...

    ...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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •