Sql

Search

mysql compare timestamp in minutes

select from_unixtime(`your_timestamp`) as lastdt from `sessions` 
WHERE from_unixtime(`your_timestamp`) >= NOW() - INTERVAL 15 MINUTE
ORDER BY your_timestamp DESC;

Comment

can we compare two timestamps in mysql

UPDATE report 1 SET status = 'time is larger' WHERE EXISTS 
  (SELECT ip_src, layer4_sport, timestamp FROM  
  (SELECT ip_src, layer4_sport, timestamp from report 1) AS tmpb  
   WHERE  report 1.layer4_sport = tmpb.layer4_sport 
   AND report 1.ip_src = tmpb.ip_src  
   AND  report 1.timestamp > tmpb.timestamp)

Comment

PREVIOUS	NEXT

Code Example
Sql :: android studio SQLiteDatabase delete all data in database
Sql :: mysql run sql file
Sql :: postgres user permissions
Sql :: oracle sql copy table without data
Sql :: postgres like case insensitive
Sql :: sql order by alphabetical
Sql :: sql set
Sql :: how to change column name in mysql
Sql :: query by column for substring sql
Sql :: installing mysql on centos 7
Sql :: sql precent format
Sql :: T-SQL - Delete Column
Sql :: drop CHECK constraint sql
Sql :: sqlserver add column
Sql :: all_dependencies
Sql :: combine 2 columns search query mysql
Sql :: how to select random rows from a table
Sql :: between keyword in sql
Sql :: limit offset sql server
Sql :: uppercase sql
Sql :: mysql how to use FIND_IN_SET function in WHERE clause ?
Sql :: insert into auto increment mysql
Sql :: SQL column name Oracle
Sql :: eliminar ultimo carcacter mysql
Sql :: how to truncate foreign key constraint table
Sql :: having count oracle two columns
Sql :: how to install mysql 8.0 windows service
Sql :: oracle create package body
Sql :: soql user profile
Sql :: sql join

Search

SQL

mysql compare timestamp in minutes

can we compare two timestamps in mysql

ADD CONTENT