Project / Support Center
Welcome, Guest. Please login or register. January 16, 2022, 07:55: PM
Home Help Search Login Register
D-Web Web Site Creator D - Web Web Site Creator On-line HTML Editor No Programming knowledge required. Web Global Net PayPal-Cart Shopping Cart System PayPal - Kart Shopping Cart System for E-Commerce over the internet, that's easy to use. Web Global Net Newsletter Manager Newsletter Manager On-line Newsletter Creator with Email Subscriber Management.
Ring Central Discount
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: show only records in a list after a specific time 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: show only records in a list after a specific time  (Read 9791 times)
admin
Administrator
******
Offline Offline

Posts: 231


« on: February 13, 2014, 11:02: PM »

show only records in a list after a specific time based on a timestamp field

use this in your where clause for after the date/time shown

WHERE event.transaction_date>'2014-02-10 19:05:59'

use this in your where clause for before the date/time shown

WHERE event.transaction_date<'2014-02-10 19:05:59'

Note :

if a record for example is 6 pm or 18:00:00 then you need to use 17:59:59 as the show after date as it would not  include records that are set at 18:00:00
Report to moderator   Logged

The Unknown Webmaster
Pages: [1] Go Up Send this topic Print 
Web Global Net Web Application & Web Development Project Center  |  Technical Issues  |  MySQL  |  Topic: show only records in a list after a specific time « previous next »
Jump to:  


Login with username, password and session length
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!