Re: [tryton-dev] Covert datetime as date in a sqlite pythonsql query
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(column as date) from >> mytable) over a sqlite file i get a similar "not good" result. Cast sqlite >> native functión can't covert to date. >> > Right, I can reproduce it on my local environemnt. In order to get a > proper date on sqlite you can use: > > SELECT Date(column) > > instead of > > SELECT Cast(column as date) > > So I ended up with the following code: > > from sql.functions import Function > > class SqlLiteDate(Function): > __slots__ = () > _function = 'DATE' > > if backend.name() == 'sqlite': > date = SqliteDate(column) > else: > date = Cast(column, 'DATE') > > Hope it helps! > This is just that i need Thanks a lot > > -- > Sergi Almacellas Abellana > www.koolpi.com > Twitter: @pokoli_srk > > -- > You received this message because you are subscribed to the Google Groups > "tryton-dev" group. > To view this discussion on the web visit https://groups.google.com/d/ms > gid/tryton-dev/906ca9f7-71dc-deef-46ee-0210e427d137%40koolpi.com. > -- You received this message because you are subscribed to the Google Groups "tryton-dev" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton-dev/CANd2Za3izns49XmA7FtRnwaFamZWK6w1%2BmFOv1DWpRF68n9mkw%40mail.gmail.com.
Re: [tryton-dev] Covert datetime as date in a sqlite pythonsql query
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 need it works for sqlite too. I tried to use anothers >> pythonsql functions like ToDate or DatePart but only work for postgresql >> too. >> > Can you show which current code do you have? > > Have you tried: > > Cast(column, 'DATE') > 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 good" result. Cast sqlite native functión can't covert to date. > > Which errors do you have? > No errors ... only not ok result > > > -- > Sergi Almacellas Abellana > www.koolpi.com > Twitter: @pokoli_srk > > -- > You received this message because you are subscribed to the Google Groups > "tryton-dev" group. > To view this discussion on the web visit https://groups.google.com/d/ms > gid/tryton-dev/5f0a2c6d-e249-5d57-6019-cc246090498b%40koolpi.com. > -- You received this message because you are subscribed to the Google Groups "tryton-dev" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton-dev/CANd2Za3RH%2BBAGGH%3Df0_A72RvsOEgYwMbeOfHqA%2BMqyvtLoP7ow%40mail.gmail.com.
[tryton-dev] Covert datetime as date in a sqlite pythonsql query
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 too. Any sugest? Thanks -- You received this message because you are subscribed to the Google Groups "tryton-dev" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton-dev/7bade533-f9b6-4a02-bbbf-bc9bb078d76f%40googlegroups.com.
