NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR Support Legacy (v4.x and earlier) v
« Previous 1 … 196 197 198 199 200 … 433 Next »
Can NextPVR accomplish these requirements?

Can NextPVR accomplish these requirements?
cbgifford
Offline

Member

Posts: 189
Threads: 20
Joined: Aug 2014
#11
2015-01-07, 11:52 PM
dumbest Wrote:I have no luck with daily recording using advanced rules.
The pending recordings created will be later and later each day.

time(start_time,'localtime') > time('20:30:00') AND time(start_time,'localtime') < time('23:00:00')

Try this instead

Code:
time(start_time,'localtime') BETWEEN time('20:30:00') AND time('23:00:00')

BETWEEN is an actual SQL clause designed for that while the > and < are math operators. Under most SQL implementation, they should work since time is stored as a serialized number but I am not that familiar with SQLite yet
Chris


Server - Intel Core I3-3210 @ 3.40GHz - 8 GB RAM - Windows 10.0 Pro - Total Storage - 5.4 TB
Two Silicondust HD Prime CC capture, 6 tuners total
Client - Intel Core I3-3210 @3.2GHz - 4GB Ram - Windows 7.0 Pro
Client - Intel Core I3-3210 @2.9GHz - 4GB Ram - Windows 10.0 Pro
NAS - Intel Core I3-3220T @ 2.8GHz - 4GB RAM - Windows 10.0 Pro (Total Storage - 25 TB)


dumbest
Offline

Junior Member

Posts: 24
Threads: 2
Joined: Oct 2013
#12
2015-01-08, 12:19 AM
cbgifford Wrote:Try this instead

Code:
time(start_time,'localtime') BETWEEN time('20:30:00') AND time('23:00:00')

BETWEEN is an actual SQL clause designed for that while the > and < are math operators. Under most SQL implementation, they should work since time is stored as a serialized number but I am not that familiar with SQLite yet

But they still produce the same results, pending recordings created is different for each day.
Thanks for helping.
I think I will start a new thread for my problem.
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)

Pages (2): « Previous 1 2


Possibly Related Threads…
Thread Author Replies Views Last Post
  NextPVR - EPG Setup - XML/XMLTV EPG - Zap2it & Zap2xml Erdrick 126 143,064 2024-01-29, 01:07 AM
Last Post: stoenjes44
  NextPVR VOD through Kodi unmich 2 1,372 2023-06-18, 03:54 AM
Last Post: sub
  Can NextPVR switch graphics mode to best match content ? madbrain 2 2,262 2021-09-25, 02:25 AM
Last Post: madbrain
  NextPVR and Remote viewing MaxiBelas 2 1,758 2021-09-07, 05:29 PM
Last Post: sub
  Help with NextPVR evinahmad86 1 1,499 2021-07-23, 07:01 PM
Last Post: sub
  Epg setting SD token NextPvr 4.2.4 casimir@zyxu.ca 1 1,655 2021-03-05, 01:38 PM
Last Post: mvallevand
  NextPVR hangs when tuning to offline channel? CormacBaptiste 2 2,021 2021-02-03, 01:29 PM
Last Post: Graham
  NextPVR V4 Web Issue meccano 3 1,978 2021-01-30, 04:20 AM
Last Post: meccano
  TV very choppy after downgrade from Nextpvr v5 riverboat2001 18 5,128 2021-01-26, 01:51 PM
Last Post: mvallevand
  Configure NextPVR Server Pliedes 1 1,882 2020-10-07, 04:59 PM
Last Post: sub

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode