Date

[cekirge]

How can i search for an item in mysql where the date of registration is within 5 hours, date is in timestamp(14) format

Thanks

[jstarkey]

Originally posted by cekirge
How can i search for an item in mysql where the date of registration is within 5 hours, date is in timestamp(14) format

Thanks

I would use the UNIX_TIMESTAMP() function in mysql:

...WHERE UNIX_TIMESTAMP( date_field) > ( UNIX_TIMESTAMP( now() ) - 18000 )

Something like that.

[cekirge]

thanks
i will try that