increase Date and time

[mescal]

Hi,

 

I need to increase a given date and time (by a flat text) with 30 seconds(incremental) on each item coming from my database.

 

exmpl:

item1 date  Apr 24, 2007 19:00:00

item2 date  Apr 24, 2007 19:00:30

item3 date  Apr 24, 2007 19:01:00

 

someone got an idea?

 

thx in advance

 

Eric  ???

 

 

[jitesh]

SELECT DATE_ADD(datetimefeild,INTERVAL 30 SECOND);

 

OR

 

SELECT datetimefeild + INTERVAL 30 SECOND

[mescal]

but that is mysql ,right?

 

i need it in PHP

 

thx

[jitesh]

Try this

 

echo date("Y-m-d H:i:s", mktime($hour,$min, $sec, $mon, $day, $year) + 30);

[mescal]

will that be something like?

 

date("Mar 24, 2007 19:00:00", mktime($hour,$min, $sec, $mon, $day, $year) + 30);

[jitesh]

date("F j, Y, g:i a", mktime($hour,$min, $sec, $mon, $day, $year) + 30);