Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trim the time from datetime

Status
Not open for further replies.
JOBARAM

JOBARAM

Programmer
May 25, 2002
52
IL
hi,
I have a datetime field 'LastActivationTime' and I want to create a query that add 1 to different field every half an hour from current time. I tried the following:
DATE_FORMAT(LastActivationTime,'%H:%i:%s') + 0.5 < DATE_FORMAT(now(),'%H:%i:%s').

Can I do that? Can I put LastActivationTime which is a datetime field istead os a string? why doesn't it work?

Thaks
Jo
 
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
396
EdLentz
EdLentz
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
414
penguinspeaks
penguinspeaks
wilsjay22
  • Locked
  • Question
Freeing up disk space from information_schema
Replies
1
Views
320
jg2828
jg2828
Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
205
Andrzejek
Andrzejek
PeDa
  • Locked
  • Question
Opening MySQL table from Microsoft Access
Replies
1
Views
190
PeDa
PeDa

Part and Inventory Search

Sponsor

Back
Top