References
Category:2011 films
Category:2010s Hindi-language films
Category:Indian romantic comedy films
Category:Indian drama films
Category:Indian films
Category:Films shot in Mumbai
Category:2010s romantic comedy films
Category:2010s comedy-drama films
Category:2010s romantic drama films
Category:2010s romantic comedy filmsHow do I delete cookies?
Most web browsers have a "clear cookies and history" function. If you have a pop-up that asks if you want to clear your browser history, say "no" and clear the cookies and history. This will remove all of your browser's stored information, including website
From Firefox:
- Open the menu and click on "Tools"
- Click on "Options" and then "Privacy"
- Click on "Clear History" and "Clear Cookies"
- Click on "OK"Q:
how to find time difference between two timestamp in SQL
I have two timestamp
timestamp1 and timestamp2. I need to calculate time difference between them. If timestamp2 is more than 2 hours apart from timestamp1, it will return NULL, else it will return difference.
Also it will not return difference if timestamp1 is also in same second of timestamp2.
Note: there are no days between these timestamp1 and timestamp2.
Example:
timestamp1 timestamp2
12:00:00 14:00:00
13:00:00 12:00:00
14:00:00 13:00:00
This example shows two rows, where
row1 (time_diff=00:00:00)
row2 (time_diff=01:00:00)
I need to get these two rows, where row2 will return time difference of 01:00:00
A:
I don't think you can do it in a single SQL statement, but this may be what you're looking for:
SELECT
timeDiff = TIMESTAMPDIFF(MINUTE, timestamp1, timestamp2),
*
FROM
table
SQLFiddle
A:
This will not count the difference in seconds, but in minutes, if the difference is 1 or 2 hours:
SELECT be359ba680
Related links:
Comments