SQLite Time Format Conditional Query

内容目录

SELECT * FROM "MyTable" t
WHERE
	( 't'.'time' > '2019-03-13 00:00:00 ' ) 
	AND ( 't'.'time' < '2019-03-13 23:59:59 ' )

Time must be written as a string in the format 2019-03-13 00:00:00 in order to be invalid.

No functions and no conversions are needed.

本作品采用知识共享署名-非商业性使用-相同方式共享 4.0 国际许可协议进行许可