2017-06-27 11:01 GMT+02:00 Sergi Almacellas Abellana :
> El 26/06/17 a les 16:31, Nicolás López Solano ha escrit:
>
>> Yes i tried. For postgresql it return a correct date but for sqlite it
>> return only the year of the datetime base column.
>>
>> If i work directly executing sql (select cast(col
El 26/06/17 a les 16:31, Nicolás López Solano ha escrit:
Yes i tried. For postgresql it return a correct date but for sqlite it
return only the year of the datetime base column.
If i work directly executing sql (select cast(column as date) from
mytable) over a sqlite file i get a similar "not
2017-06-26 16:10 GMT+02:00 Sergi Almacellas Abellana :
> El 26/06/17 a les 16:07, Nicolás López Solano ha escrit:
>
>> Hi,
>>
>> I need to writte a pythonsql query with a date column computed converting
>> a datetime column. I'm using Cast function to do that but only works for
>> postgresql and i
El 26/06/17 a les 16:07, Nicolás López Solano ha escrit:
Hi,
I need to writte a pythonsql query with a date column computed
converting a datetime column. I'm using Cast function to do that but
only works for postgresql and i need it works for sqlite too. I tried to
use anothers pythonsql func
Hi,
I need to writte a pythonsql query with a date column computed converting a
datetime column. I'm using Cast function to do that but only works for
postgresql and i need it works for sqlite too. I tried to use anothers
pythonsql functions like ToDate or DatePart but only work for postgresql
