Breaking down by Hour in between two dates

$10-30 USD

Completed

Posted

over 8 years ago

$10-30 USD

Paid on delivery

from mytable 3 fields. customer id, date time in, date time out. CustumerID Date_Time_In Date_Time_Out 12345 3/24/2014 13:28 3/24/2014 14:44 Expected out put: from my table create new table as below. 3 columns from my table and a breakdownbyEvery1h column. below is example. i dont want this in a union view. CustumerID Date_Time_In Date_Time_Out BreakdownEvery1HR 12345 3/24/2014 13:28 3/24/2014 14:44 3/24/14 1:28 PM 12345 3/24/2014 13:28 3/24/2014 14:44 3/24/14 2:00 PM 12345 3/24/2014 13:28 3/24/2014 14:44 3/24/14 1:00 PM 12345 3/24/2014 13:28 3/24/2014 14:44 3/24/14 2:00 PM 12345 3/24/2014 13:28 3/24/2014 14:44 3/24/14 3:00 PM 12345 3/24/2014 13:28 3/24/2014 14:44 3/24/14 4:00 PM

SQL

Project ID: 8207805

About the project

3 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@VeteranLK

Sr, I'm a DB Engineer, can create the required output > should that be a table or a view? > MySQL or Microsoft SQL ?

$25 USD in 0 day

5.0

(19 reviews)

4.2

3 freelancers are bidding on average $33 USD for this job

@zeunix

Hello, Thank you for taking the time to review our bid! We are really eager to work on your project. We are a highly motivated team of adept professionals so we can deliver you the work timely. Thank you for your consideration.

$49 USD in 1 day