Hi Fatih,
not tested, but this should work and is I think what you want. Good luck.
"SELECT * from TABLE t where t.Date1 >= @0 AND t.Date2 <= @1",
date1.ToString("yyyy-MM-dd HH:mm:ss"), date2.ToString("yyyy-MM-dd HH:mm:ss")
-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John McKown
Sent: December-30-13 08:05
To: General Discussion of SQLite Database
Subject: Re: [sqlite] How to get data between two dates in SQLite with C#?
Fatih,
I think you'll need to show some code and what it is doing (i.e. I do "..."
and I get "...", but I want "...") before anyone can really help you.
On Sun, Dec 29, 2013 at 7:08 PM, Fatih BURAL <fatihbu...@hotmail.com> wrote:
> Hi,
>
> My name is Fatih, I'm having a trouble about getting data between two
> different dates in SQLite with C# code. I tried all the ways even I
> asked questions about this situation to some MVPs but I didn't solve
> it. I want to use SQLite but if I don't solve this query I will have
> to use SQLCE or something that I don't like to use.
>
> Could you please help me to solve that problem?
>
>
>
> Teşekkürler & Saygılar
> Thanks & Regards
> -------------------------
> Fatih BURAL
>
> Software Developer
> -------------------------
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
This is clearly another case of too many mad scientists, and not enough
hunchbacks.
Maranatha! <><
John McKown
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
