select from database where date = 27

[hali alduhoky]

hello guys, i'm new user here and i very happy between you :)


i have mistake with mysql database i do not know how i can solve it :(

i have mysql table and topics and when user add new topic the date in mysqldatabase is like time() . like 3243565 or 343535355

i wanna to select * from mysql query where day of the topic like 27

note : the date format in the tables is like time() .


i hope to solve my mistake here :(
because i'm very tired and i do not know who can help my i think here i will solve my mistake :)