Rick Ratchford wrote:
> So what I need to do then is to make the return of strftime of type INT.
>
> Can CAST(strftime('%d', Date), INTEGER) be used in this context, or is there
> another way?
>
>
Rick,
You could use a cast (with correct syntax) as you have suggested
CAST(strftime('%d', Date) AS INTEGER)
Or you could simply provide the day you are checking for as a string. To
do this, surround the number with single quotes to turn it into a string
literal.
SQLString = "SELECT strftime('%d', Date) as Day, IsSwingTop1 as Tops,
IsSwingBtm1 as Btms " & _
"FROM TmpTable WHERE Day = '11'"
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
