January 7, 2017

SQL - How to check database timestamp value with current timestamp



SQL - Check database timestamp value with current timestamp

- I find a solution for check sql database timestamp value with current timestamp.

Example:

If you want to get past value from current time:

- SELECT * FROM <tablename> WHERE <fieldname> >= UNIX_TIMESTAMP(currentdate())

Enjoy!

2 comments:

1980s Photo Prompts: Easy Online Copy & Paste

Are you on a quest to enhance your photography projects with a touch of nostalgic flair? Look no further than 1980s photo prompts. These car...