Add(MainForm,12092450,224,189)
{
 Width=530
 Height=277
 Position=1
 Point(onClose)
 link(onCreate,6991059:doOpen,[])
 link(onClose,6991059:doClose,[])
}
Add(MTStrTbl,3686310,542,161)
{
 @Color=11206570
 Top=20
 Width=522
 Height=223
 Align=5
 Name="1"
 Grid=0
}
Add(DS_SQLite,6991059,266,203)
{
 @Color=5636095
 Name="11"
 FileName="test222.db"
 link(onOpen,11629369:doWork,[])
}
Add(DSC_Query,11511635,430,287)
{
 @Color=5636095
 DSManager="11"
 link(onQuery,14717227:doAddRow,[])
 link(onColumns,14717227:doAddCols,[])
 link(onError,8904597:doWork3,[(581,307)])
}
Add(MST_DB,14717227,479,287)
{
 @Color=11206570
 MSTControl="1"
}
Add(Message,3808633,598,301)
{
}
Add(DSC_Exec,13846613,542,203)
{
 @Color=5636095
 SQL="CREATE TABLE tab1( amount INTEGER, dt DATETIME );\r\n\r\nINSERT INTO tab1 VALUES(10, '2010-07-01 10:10');\r\nINSERT INTO tab1 VALUES(20, '2010-08-01 11:15');\r\nINSERT INTO tab1 VALUES(5, '2010-09-01 20:00');\r\nINSERT INTO tab1 VALUES(10, '2010-10-01 10:20');\r\nINSERT INTO tab1 VALUES(20, '2010-11-01 11:30');\r\nINSERT INTO tab1 VALUES(5, '2010-12-01 20:30');\r\n"
 DSManager="11"
 link(onError,8904597:doWork1,[(581,216)])
}
Add(HubEx,8904597,577,301)
{
 link(onEvent,3808633:doMessage,[])
}
Add(Check,11629369,346,203)
{
 Caption="Включить при первом запуске"
 link(onEvent,13846613:doExec,[])
}
Add(Edit,1109390,353,280)
{
 Width=522
 Align=2
 Text="SELECT sum(amount) AS Количество from tab1 WHERE dt>= '2010-08-01' and dt<= '2010-11-01';"
 link(onEnter,11667648:doEvent1,[])
}
Add(Hub,11667648,399,287)
{
 link(onEvent1,11511635:doQuery,[])
 link(onEvent2,1109390:doText2,[(419,300)(419,318)(341,318)(341,293)])
}

SELECT datetime(1721424.5+d2)

Add(MainForm,7786459,266,308)
{
}
Add(Time,12210462,364,203)
{
 Point(DateTime)
}
Add(DateConvertor,4559047,371,259)
{
 Mode=9
 Format="dd.MM.yyyy hh:mm:ss.000"
 Point(Data)
 link(onResult,5524324:doText,[])
 link(Data,12210462:DateTime,[])
}
Add(Edit,5524324,448,259)
{
 Left=15
 Top=25
 Width=210
 Text=""
}
Add(Timer,7777439,266,259)
{
 link(onTimer,6429160:doEvent1,[])
}
Add(Hub,6429160,322,259)
{
 link(onEvent1,4559047:doConvert,[])
 link(onEvent2,1593159:doConvert,[(352,272)(352,342)])
}
Add(DateConvertor,487435,504,336)
{
 Mode=9
 Format="yyyy-MM-dd hh:mm:ss.000"
 Point(Data)
 link(onResult,13870018:doText,[])
}
Add(Edit,13870018,588,336)
{
 Left=15
 Top=50
 Width=210
 Text=""
}
Add(DateConvertor,1593159,448,336)
{
 Mode=8
 Format="dd.MM.yyyy hh:mm:ss.000"
 Point(Data)
 link(onResult,487435:doConvert,[])
 link(Data,5524324:Text,[])
}
Add(InfoTip,15737684,406,301)
{
 Info=#9:Convertor|
 Width=162
 Height=88
 Margin=10
}

Add(Edit,1109390,311,245)
{
 Width=522
 Align=2
 Text="SELECT sum(amount) AS Количество from tab1 WHERE substr(dt,1,10)>= '2010-08-01' and substr(dt,1,10)<= '2010-11-01';"
}

Select date(имя колонки с DateReal)