Lost Password?


Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Find Date/Time
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 12-04-2006, 07:49 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 Find Date/Time
Is there a way in MySQL to determine if a date is older than 20 minutes?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 12-20-2006, 08:17 AM
mylegoh mylegoh is offline
Newbie
  
Join Date: Sep 2006
Location: London
Age: 41
Posts: 25
Rep Power: 8
mylegoh is on a distinguished road
Default Use Addtime
Hi,

You need to use the addtime function in MySQL see http://dev.mysql.com/doc/refman/4.1/...functions.html for full syntax information.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-04-2007, 06:35 AM
Magnus Magnus is offline
Newbie
  
Join Date: Jan 2007
Posts: 5
Rep Power: 0
Magnus is on a distinguished road
Default
How have you stored that time?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 01-04-2007, 05:58 PM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Posts: 9,224
Last Blog:
Ext JS or Ext GWT
Rep Power: 20
Jordan is just really niceJordan is just really niceJordan is just really niceJordan is just really nice
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
You can store in the language you are executing the query in such as PHP. Otherwise, you will only be able to display it in MySQL.
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
The CodeCall Wiki is now fully integrated with vBulletin users! Check it out and add some new pages!
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
how to find derivative in java sania21 Java Help 1 05-15-2007 07:35 AM
How to find out which record the user clicked? reachpradeep Perl 1 03-03-2007 03:24 PM
A great find: Beginning Perl techni68 Perl 0 01-21-2007 06:39 AM
Find last Monday Chan PHP Forum 4 12-04-2006 12:18 PM
Where to find PHP tutorials Jordan PHP Forum 1 11-09-2005 02:23 PM


All times are GMT -5. The time now is 12:37 PM.

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: 98%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads