[Gambas-user] SQLTE3 >date function

Bill-Lancaster bill-lancaster at ...2231...
Sun Sep 19 14:13:20 CEST 2010


I want to extract records between 2 dates from a date type field (TransDate)
but using:-

hResult = FMain.$hConn.Find("transactions", "TransDate >= '2009-07-01')
produces the same result as
hResult = FMain.$hConn.Find("transactions", "TransDate > '2009-07-01').

Also sometimes records 1 day older than requested can be returned.

Using strftime seem very tricky for say dates between 2009-06-30 and
2010-07-01.

Any thoughts?

Bill Lancaster
-- 
View this message in context: http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p29751718.html
Sent from the gambas-user mailing list archive at Nabble.com.





More information about the User mailing list