Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL Server query to get data for a particular date and time

select * 
from table_name
WHERE  (SELECT  CONVERT(char(5),SYSDATETIMEOFFSET() AT TIME ZONE 'Central Standard Time', 108))                        
  BETWEEN   CONVERT(VARCHAR(5),column_name,108) AND CONVERT(VARCHAR(5), DATEADD(mi, 30,column_name),108)      
Comment

PREVIOUS NEXT
Code Example
Sql :: sql query inner join 3 tables 
Sql :: sqlite commands 
Sql :: how to get nth number in sql 
Sql :: sql search all tables for attributes 
Sql :: unique in sql server 
Sql :: oracle inner join 
Sql :: import mysql database command line 
Sql :: mysql group concat 
Sql :: substring sql 
Sql :: 0 
Sql :: how to delete database in mysql 
Sql :: union all query in sql 
Sql :: postegresql update to null 
Sql :: oracle grant directory 
Sql :: union vs union all in sql 
Sql :: mysql find max value row 
Sql :: export mysql table to file 
Sql :: set column width in sqlplus 
Sql :: tsql edit table column 
Sql :: insert to postgres table 
Sql :: docker hub mysql 
Sql :: what is denormalization in sql 
Sql :: isnull in sqlite 
Sql :: insert or update sql query 
Sql :: oracle step procedure 
Sql :: mysql custom sort order 
Sql :: what is drop in sql 
Sql :: desinstaller mysql sur ubuntu definitivement 
Sql :: extract postgresql 
Sql :: SQL:RANK function to delete duplicate rows 
ADD CONTENT
Topic
Content
Source link
Name
9+9 =