[PHP] Get Rows From Same Day From Column

[Berk]

Hey,
it's been a long time since I posted here and now I'm back,
I'm wondering, how can I get like today registered users from database, time is stored at account_created column.
I don't really know how to do this so I could not try, forgive me.

Thanks.

 

[MayoMayn]

What format is it stored in? TIMESTAMP? UNIX_TIMESTAMP? DATE?
Next time provide a bit more sufficient information so it'd be easier to help you out, all we practically can do atm is guessing

You must be registered for see links

 

[Weasel]

What type is your account_created column?

 

[Berk]

Oh yeah, forgot to mention that it's UNIX timestamp.

 

[MayoMayn]

This should do it.

SELECT * FROM tableName WHERE account_created >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 DAY))

You must be registered for see links

 

[Berk]

This should do it.

SELECT * FROM tableName WHERE account_created >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 DAY))

You must be registered for see links

Thank you, this worked.