linux apache mysql php

Tutorials related to system administration, programming and database management.

Friday, April 5, 2013

Date subtraction in MySQL

MySQL: select all records from a table using date subtraction.


SELECT tbldata.* FROM tbldata WHERE (tbldata.DateAdded <= DATE_SUB(now(), INTERVAL 3 HOUR));


source: http://www.daniweb.com/web-development/php/threads/448140/time-difference-in-mysql
Posted by linux apache mysql php at 4:16 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

Blog Archive

  • ▼  2013 (21)
    • ►  May (8)
    • ▼  April (13)
      • Linux: check available space on each filesystem
      • Ubuntu: Add new domain / subdomain in apache
      • change date.timezone in php
      • create and delete symbolic links in linux
      • PHP increase file upload size
      • PHP Disable File Upload
      • Linux: start / stop / restart apparmor daemon
      • Restart Apache in all Linux distributions
      • Updated Debian 6.0: 6.0.7 released
      • Ubuntu 13.04 (Raring Ringtail) Beta 2 released
      • Ubuntu 8.04 (Hardy Heron) server, 10.04 (Lucid Lyn...
      • MySQL's creator on why the future belongs to MariaDB
      • Date subtraction in MySQL

Pages

  • Linux Apache Mysql Php
  • Privacy Policy

About Me

linux apache mysql php
Tutorials related to system administration, programming and database management.
View my complete profile

Contact Form

Name

Email *

Message *

linuxapachemysqlphp5.blogspot.com. Simple theme. Powered by Blogger.