Lost Password?


Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Days from date
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-21-2006, 06:05 PM
Nightracer's Avatar   
Nightracer Nightracer is offline
Programmer
  
Join Date: Jun 2006
Posts: 131
Rep Power: 9
Nightracer is on a distinguished road
Default Days from date
If I have a date in mysql say 9-20-2006, is there a query I can run that will get the days since then until today?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 09-22-2006, 12:53 PM
WingedPanther's Avatar   
WingedPanther WingedPanther is offline
Super Moderator
  
Join Date: Jul 2006
Age: 35
Posts: 3,275
Last Blog:
wxWidgets is NOT code ...
Rep Power: 36
WingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to all
Default
I believe you can use > and < in WHERE clauses on dates.
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum
Programming is a branch of mathematics.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 09-22-2006, 01:54 PM
Void's Avatar   
Void Void is offline
Programming Expert
  
Join Date: Jun 2006
Posts: 411
Rep Power: 11
Void is on a distinguished road
Default
Use the TO_DAYS() function of mysql.

Example:
Code:
SELECT TO_DAYS(CURDATE()) - TO_DAYS(my_field) FROM tbl;
__________________
Void
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date in Oracle 8 Ronin Database & Database Programming 6 08-17-2007 01:25 AM
Translate date into your language Jaan PHP Tutorials 5 06-01-2007 06:23 PM
Calculate Quarterly dates from a Start date reachpradeep Database & Database Programming 0 03-05-2007 08:19 AM
PHP:Tutorial The Date John PHP Tutorials 0 01-10-2007 07:10 PM
Finding Date NeedHelp C# Programming 3 12-08-2006 05:37 PM


All times are GMT -5. The time now is 11:16 AM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

WingedPanther ........ 2753.6
Xav ........ 2704
Brandon W ........ 1702.32
John ........ 1207.73
marwex89 ........ 1175.24
morefood2001 ........ 966.05
dcs ........ 655.75
Steve.L ........ 475.59
orjan ........ 418.58
Aereshaa ........ 383.54

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 97%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads