Jump to content

Archived

This topic is now archived and is closed to further replies.

atstockland

subtract 15 minutes from mysql TIME

Recommended Posts

Hi all -

 

Im have data stored in a mysql DB using the data type of TIME.  I dont want dateTime as I dont care about the date....just time.  I want to simply subtract 15 minutes from that time.  So, if the time in the database reads 13:00:00 I want to subtract 15 minutes from that so it reads 12:45 PM.

 

I have tried using:

$tourTime = $row_Recordset1['TheTimeInMyDatabase'];

$tourTime_seconds = strtotime ($tourTime);

$meetingTime_seconds = $tourTime_seconds - 900;

$adjustedTime = time ("h:i p", $meetingTime_seconds);

 

This seems like a really easy thing to do.  Im glad its a struggle for me because its teaching me more about php.....but now Im ready for it to work.

 

Thanks

Adam

Share this post


Link to post
Share on other sites

Ill give that a try.  Id rather do it with php....than in the mysql query.  Is there a reason to do it one way or the other?

 

thanks for the reply

Share this post


Link to post
Share on other sites

Doing it in the MySQL query is much faster.

 

 

SELECT DATE_SUB( `dateCol`, INTERVAL 15 MINUTE ) as `dateLess15`

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.