Tony Pearce
asked on
MySQL select a row where datetime (epoch) over 20 minutes old
Hi,
I have a column called datemade, it is stored in this type of format:
1238404018
Epoch?
What i want to do is only selct rows that are over 20 minutes old?
SELECT *
FROM salestable
WHERE datemade +??
Then I'm stuck
Any suggestions please????
I have a column called datemade, it is stored in this type of format:
1238404018
Epoch?
What i want to do is only selct rows that are over 20 minutes old?
SELECT *
FROM salestable
WHERE datemade +??
Then I'm stuck
Any suggestions please????
SELECT *, from_unixtime(datemane)
FROM salestable
WHERE unix_timestamp('yourtime')
better version sorry
FROM salestable
WHERE unix_timestamp('yourtime')
better version sorry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much, complete and accurate
FROM salestable
with this you will get time in normal format