INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Help converting data from SQL table

Help converting data from SQL table

(OP)
Good Morning.. I'm using crystal to report off a sql database.. there is a duration field which is minutes but it pulls x,xxx,xxx.xx with a formula how do I convert that to minutes?


thanks for any help!! conversions make my head hurt

RE: Help converting data from SQL table

Hi,

Are you saying that your duration in minutes field displays as millions to two decimal places?

So are you expecting to see duration on the order of camera shutter speeds or the amount of time it takes to walk around the block or the time it would take a space ship to get to the nearest star or on the order of what?

If the duration is displayed in minutes, then to convert to minutes you multiply by 1.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Help converting data from SQL table

(OP)
For example.. a duration field shows 5 minutes on the form.. the sql table is showing 300,000.00 when i report from crystal.. how do i convert the field to show 5 instead?

RE: Help converting data from SQL table

Well, your original question was very impossible to understand, with x,xxx,xxx.xx which could have been ANYTHING.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Help converting data from SQL table

(OP)
thanks SKip.. that was helpful clown

RE: Help converting data from SQL table

By deduction there are ...

5 minutes * 60 seconds/minute = 300 seconds

1000 milliseconds/second * 300 seconds = 300,000 milliseconds.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close