sql - Time difference in minutes between two times -


been struggling difference in minutes between 2 times. 1 time comes field of data type time in sql server. other value string added sql query. i'm running in ssrs 2008 r2 looks this:

datediff(mi, convert(time, '23:59:59'), _travel.start_time) time_difference

i error: conversion failed when converting date and/or time character string

i've tried casting '23:59:59' time type 'as time' similar error. have tried declaring variable ssrs won't allow it. try give similar error. time 23:59:59 same, _travel.start_time whatever in field in db. output _travel.start_time in format 00:00:00

any ideas how can difference in minutes between 23:59:59 , db value? ta

added:

can't believe it. _travel.start_time varchar not time. have tried 

datediff(convert(time, '23:59:59'), convert(time, _travel.start_time))

but still getting same error. however, have noticed there nulls/empty fields in _travel.start_time field

i see no issue have, unless ssrs issue or _travel.start_time not of type time.

see this: sql fiddle

sample sql:

-- sample trimming time portion off datetime select datediff(mi, convert(time, '23:59:59'),         ltrim(right(convert(varchar(20), getdate(), 100), 7))) time_difference  -- sample time conversion of datetime select  datediff(mi, convert(time, '23:59:59'),           convert(time, getdate())) time_difference

in addition, have tried converting db value:

select datediff(mi, convert(time, '23:59:59'),         convert(time, _travel.start_time)) time_difference

-

Comments

Post a Comment

Popular posts from this blog

android - Automated my builds -

i have multiple app , android project want automated in build , release sequence. have ant script build , create apk of app. want have 1 script or ant file start build sequence app. maybe don't konw search, can't find easy documentation on ant. the point of use jenkins ant (or maven, i'm not sure of difference between them now) automated build sequence when people commit on project. any int appreciated maven dependencies (over ant) don't need pass around jars. recommend maven on ant day. syntax , overall process easier understand, @ end of both build tools. if able to, more recommend upgrading gradle. easy create different build types , create them ./gradlew assemble here project jake wharton can see power of gradle. there release , debug build, can make lot more if like. https://github.com/jakewharton/u2020 here android docs gradle http://tools.android.com/tech-docs/new-build-system/user-guide . if can't find looking here, check out main grad...
Read more

how to proxy from https to http with lighttpd -

i have internal site (192.168.2.1) accessible http on different server run public web-server using lighttpd. can make internal site accessible outside work follows $http["host"] == "internal.example.com" { ... proxy.server = ( "" => ( "internal" => ( "host" => "192.168.2.1", "port" => 8000 ) ) } this works, use https outside world. question is, how can proxy going https http ? i've tried this: $server["socket"] == ":443" { $http["host"] == "internal.example.com" { ... proxy.server = ( "" => ( "internal" => ( "host" => "http://192.168.2.1", "port" => 8000 ) ) } } but doesn't seem wor...
Read more

javascript - jQuery get link id -

i'm trying id-attribute of dynamic generated table. if click on first link want "editemploee-4". <table id="example" class="table span12 table-bordered table-hover"> <thead> <tr> <th>firstname</th> <th>lastname</th> <th>edit</th> </tr> </thead> <tbody> <tr> <td>person 1</td> <td>name person 1</td> <td><a href="#" class = "editdialog" id="editemployee-4"><img src="img/edit.png" height="20" /></a></td> </tr> <tr> <td>person 2</td> <td>name person 2</td> <td><a href="#" class = "editdialog" id="editemployee-5"><img src="img/edit.png" height="20" />...
Read more