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

Reply via email to