select TheDate from Dates where TheDate == date('now');

The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

>-----Original Message-----
>From: sqlite-users [mailto:sqlite-users-
>] On Behalf Of Csányi Pál
>Sent: Thursday, 12 April, 2018 09:06
>To: SQLite mailing list
>Subject: Re: [sqlite] SELECT with CASE
>2018-04-12 17:00 GMT+02:00 Peter Da Silva
>> One of the lines of the output does indeed have '2018-04-12' as
>Indeed, I did not notice.
>Then how can I get only that date from the Dates table - which is
>equal to the current date?
>sqlite-users mailing list

sqlite-users mailing list

Reply via email to